SAP C_HANASUP_1 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C_HANASUP_1
Exam Name/Title: SAP Certified Support Associate - SAP HANA 1.0
Certification Provider: SAP
Corresponding Certification: SAP-Certifications

Exam Questions: 89
Updated On: Oct 04, 2026

Question #28

You are asked to configure the SAP HANA database to recompile every query prior execution. What do you have to disable to accomplish this?

A. The SQL plan cache

B. The expensive statements trace

C. The SQL result cache

D. The SQL trace

Discussion 0

Correct Answer: D Vote an answer

Question #29

In the SAP HANA studio Administration Editor, for the following purposes can you use the Sessions subtab of the Performance tab? (Choose two)

A. To configure the maximum allowed concurrent sessions

B. To view memory consumption by session

C. To set up session-based alerts

D. To investigate blocking situations

Discussion 0

Correct Answer: B,D Vote an answer

Question #30

How can you avoid filling up the space of the log backup file area?

A. Change the log_backup_timeout_s to a small value.

B. Enable automatic log backup.

C. Increase the value of the log_segment_size_mb parameter.

D. Disable automatic log backup.

Discussion 0

Correct Answer: B Vote an answer

Question #31

Why do you configure a standby host?

A. To share storage between several active data centers

B. To reduce recovery time from an outage

C. To ensure high performance during replication and reading processes

D. To add more capacity disk storage

Discussion 0

Correct Answer: B Vote an answer

Question #32

You have to set the alert levels for CPU utilization:
Low alert-75%
Medium alert-85%
High alert-95%
You have opened the ConfigureCheck threshold tab in the Administration editor of the SAP HANA studio To which values do you set the alert levels in the Check Host CPU Utilization row?

A. 75, 85, 95

B. 25,15,5

C. 0.75, 0.85, 0.95

D. 0.25, 0.15, 0.05

Discussion 0

Correct Answer: A Vote an answer

Question #33

In SAP HANA, the automatic backup is disabled. The log area has grown and now the file system is full. The database has frozen. After you stop the database , what do you have to do to restart SAP HANA?

A. 1.
Restart the server.
2.Copy the log into a new folder.
3.Execute the log backup into the SAP HANA studio.
4.Update the global.ini file with the new folder path.

B. 1.
Restart the server
2.Execute the log backup in the SAP HANA studio.
3.Copy the log into a new folder.
4.Update the global.ini file with the new folder path.

C. 1.
Initialize the log area from the file system folder.
2.Restart the server.
3.Execute the log backup into the SAP HANA studio.
4.Refresh the global.ini file.

D. 1.
Copy the log into a new folder.
2.Update the global.ini file with the new folder path.
3.Restart the server and execute the log backup in the SAP HANA studio.
4.Copy the log to the initial folder and restore the global.ini file.

Discussion 0

Correct Answer: D Vote an answer

Question #34

Which of the following events can trigger a delta merge? (Choose two)

A. Memory consumption of delta storage exceeds a specified limit.

B. The delta log for a columnar table drops below a defined limit.

C. Memory consumption of delta storage drops below a specified limit.

D. The delta log for a columnar table exceeds a defined limit.

Discussion 0

Correct Answer: A,D Vote an answer

Question #35

What does a data snapshot do?

A. It generates a frozen point-in-time set of data

B. It writes data from memory to the persistence layer

C. It creates a backup of the database

D. It clones the database to an exportable file

Discussion 0

Correct Answer: C Vote an answer

Question #36

How do you determine the list of open transactions on an SAP HANA database? (Choose two)

A. Run an SQL query against the view SYS.TRSACTIONS_HISTORY.

B. Run an SQL query against the view SYS.M JTRSACTIONS.

C. In the SAP HANA studio, double-click on Open Transactions in the System Information tab of the Administration editor.

D. In the SAP HANA studio, double-click on Transactions double-click on Open Transactions.

Discussion 0

Correct Answer: A,C Vote an answer

Download Free SAP C_HANASUP_1 Demo

Simply submit your e-mail address below to get started with our free demo of your SAP C_HANASUP_1 exam.