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: May 31, 2026

Question #19

On an SAP HANA production system /the log area has grown and the file system is now full. This has resulted in a database freeze. Which parameters must you set to avoid this situation in the future? (Choose two)

A. enable_auto_log_backup = no

B. log_mode = normal

C. log_mode = overwrite

D. enable_auto_log_backup = yes

Discussion 0

Correct Answer: B,D Vote an answer

Question #20

How can you set configurations at the host level using the SAP HANA studio?

A. Enter values in the Host column in the Configuration tab in the Administration editor

B. Update settings in the _SYS_REPO.CHANGE_ENTRIES table

C. Right-click on a row in the Host column of the Configuration tab in the Administration editor. Select Configure Table and change settings

D. Update settings in the_SYS_REPO.CHANGES table

Discussion 0

Correct Answer: C Vote an answer

Question #21

You have an application that runs on the SAP HANA database. The application loads relatively large volumes of data for hint to the database.
Which mergedog configuration parameter in the indexserver.ini file must you set to accomplish this?

A. mermory_merge_ decision_func.

B. auto_ merge_decision_func.

C. smart_merge_enabled.

D. max_delta_memsize.

Discussion 0

Correct Answer: C Vote an answer

Question #22

How can you resolve a Disk Full event?

A. 1.
Add additional storage space.
2.Mark the event as handled in the Overview tab of the Administration editor.
3.Resume the SAP HANA database.

B. 1.
Add additional memory.
2.Mark the event as handled in the Alerts tab of the Administration editor
3.Resume the SAP HANA database.

C. 1.
Mark the event as handled in the Overview tab of the Administration editor.
2.Add additional memory.
3.Resume the SAP HANA database.

D. 1.
Stop the SAP HANA database.
2.Mark the event as handled in the Overview tab of the Administration editor.
3.Restart the SAP HANA database.

Discussion 0

Correct Answer: A Vote an answer

Question #23

In the Volumes tab of the SAP HANA studio Administration Console, which of the following provides you with the total disk space (in MB)?

A. The value in the Volume Size (MB) column

B. The value of the Total Disk Size (MB) column minus the value of the Log Volume Size (MB) column.

C. The value in the Total Disk Size (MB) column.

D. The value of the Volume Size (MB) column minus the value of the Used Disk Size (MB) column.

Discussion 0

Correct Answer: C Vote an answer

Question #24

Which column do you use to identify long-running SQL statements within the SQL Plan Cache view?

A. TOTAL_EXECUTION_OPEN_TIME

B. AVG_EXECUTION_OPEN_TIME

C. AVG_EXECUTION_TIME

D. TOTAL_EXECUTION _TIME

Discussion 0

Correct Answer: C Vote an answer

Question #25

When you configure an SQL trace with trace level ALL, which of the following are recorded to the trace file? (Choose three)

A. Data returned by queries

B. Overall execution time of each statement

C. Unique indexes used

D. Unique constraint violations

E. Number of records affected

Discussion 0

Correct Answer: B,D,E Vote an answer

Question #26

Which of the following can you use to create an index in the SAP HANA database? (Choose two)

A. 1.
Open the SAP HANA studio
2.Expand the Content tree and select the package.
3.Expand the Package tree.
4.Select New and then Decision table.

B. Execute a CERATE INDEX SQL statement from the SQL console.

C. Execute a CE_PROJECTION statement from a stored procedure.

D. 1.
Open the SAP HANA studio
2.Expand the Catalog tree and select the schema.
3.Expand the Table tree.
4.Select Open Definition and create an index

Discussion 0

Correct Answer: B,D Vote an answer

Question #27

Which of the following are held in SAP HANA used memory? (Choose two)

A. Temporary computations

B. Free memory pool

C. Column and row tables

D. Heap memory

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.