SAP Certified Support Associate - SAP HANA 1.0 - C-HANASUP-1 Exam Questions [2026]

QUESTION NO: 1
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

Correct Answer: A

QUESTION NO: 2
Which of the following can you use to schedule a periodic SAP HANA database backup?

A. SAP HANA studio B. hdbsql C. Transaction LTR D. Transaction DBACOCKPIT

Correct Answer: A

QUESTION NO: 3
Which parameters can you configure for an expensive statement trace? (Choose two)

A. Passport trace level B. Trace file C. Trace status D. Threshold duration

Correct Answer: C,D

QUESTION NO: 4
You cancelled a running backup. Where in the SAP HANA studio can you verify that the cancellation was successful?

A. In the Session subtab of the Performance tab of the Administration edit B. In the System Information tab of the Administration editor C. In the Backup folder of the Navigator pane D. In the vies M_BACKUP_CATALOG_FILE in the SYS schema

Correct Answer: A

QUESTION NO: 5
Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease? (Choose two).

A. Too many information models have been created. B. Backup jobs are running. C. Large tables are updated with frequent delta merges D. Many replication jobs are running.

Correct Answer: C,D

QUESTION NO: 6
Which of the following can you determine using the Backup catalog report? (Choose two)

A. The path for the backup files B. When to execute the net backup C. Which backup files are obsolete D. Whether a recovery is possible

Correct Answer: C,D

QUESTION NO: 7
When you are monitoring hosts statuses, you find that the status of one of the index server services is IGNORE (gray square).
What is the reason for this?

A. The host of the service is configured as a worker host. B. The host of the service is configured as a standby host. C. The host's actual role is different from its configured role. D. The index server service has been stopped.

Correct Answer: B

QUESTION NO: 8
Your client tells you that the SAP HANA database backup is not working.
In the SAP HANA studio, where could you start to investigate the issue? (Choose three)

A. Administration editor - Alerts B. SYS schema C. Administration editor - Performance overview D. _SYS_BI schema E. Administration editor - System Information

Correct Answer: A,B,E

QUESTION NO: 9
Which steps are required to identify dominant SQL statements? (Choose two)

A. Sort expensive statements by total execution time; from largest to smallest B. Go to the Expensive Statements Trace tab on the Performance tab C. Sort SQL plan cache by total execution time, from largest to smallest D. Go to the SQL Plan Cache tab on the Performance tab

Correct Answer: C,D