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 #1

How can you identify often-used SQL statements? Note: 2 correct answers

A. Create an SQL query on the view SYS.M_SQL_PLAN_CACHE

B. Review the Sessions subtab in the Performance tab of the SAP HANA studio Administration editor

C. Review the SQL Plan Cache subtab in the Performance tab of the SAP HANA studio Administration editor

D. Create an SQL query on the view SYS.M_CONNECTION_STATISTICS

Discussion 0

Correct Answer: A,C Vote an answer

Question #2

You have enabled an SQL trace. The resulting trace file is rather large. You have downloaded the trace file to your local computer and want to remove it from this system.
Which steps must you perform to accomplish this?

A. 1.
Delete the SQL trace file from the Diagnosis Files tab.
2.Deactive SQL trace in the Trace Configuration tab.

B. 1.
Deactive SQL trace in the Trace Configuration tab.
2.Open the SQL trace file and delete the contents.

C. 1.
Deactive SQL trace in the Trace Configuration tab,
2.Delete the SQL trace file from the Diagnosis Files tab.

D. 1.
Open the SQL trace file and delete the contents.
2.Deactive SQL trace in the Trace Configuration tab.

Discussion 0

Correct Answer: C Vote an answer

Question #3

In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?

A. Filter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab.

B. Check the Record Locks report of the System Information tab.

C. Filter on the DURATION_MICROSEC column in the Expensive Statements Trace tab of the Performance tab.

D. Check the Overall Workload report of the System Information tab.

Discussion 0

Correct Answer: A Vote an answer

Question #4

Your SAP HANA project has gone live. The client requires to build a new sandbox environment, using a copy of the production data, for prototyping and technical upgrades What is the SAP recommended approach to meet the requirement?

A. Install a new SAP HANA instance on your own Restore the production database from a data backup

B. Make a copy of the file system of the production appliance with 'tar' Create a clone in the sandbx appliance from this tar file.

C. Install a new SAP HANA instance on you own Deploy SAP HANA packages to this new sandbox instance

D. Install a new SAP HANA instance with help from the hardware vendor Restore the production database from a data backup

Discussion 0

Correct Answer: D Vote an answer

Question #5

What do you have to consider when you want to unpartition an SAP HANA table? (Choose three)
Unpartitioning blocks concurrent read access to the table during the process.

A. Unpartitioning can table a long time to complete.

B. Only read access is allowed during the unpartitioning process.

C. An exclusive lock on the table is required.

D. Only tables of more than 2 billion rows can be unpartitioned.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #6

Which of the following are prerequisites for the integration of SAP Solution Manager and SAP HANA? (Choose two)

A. Configure SAP Early Watch Alets for SAP HANA.

B. Create a connection to SAP HANA in the managed system configuration.

C. Register SAP HANA in the System Landscape Directory.

D. Configure SAP NetWeaver Landscape Virtualization Management.

Discussion 0

Correct Answer: B,C Vote an answer

Question #7

What are the purposes of executing a delta merge operation in an SAP HANA database? (Choose three)

A. To move inserted records from delta storage to column store

B. To move updated records from delta storage to column store

C. To move merge data from row tables to column store

D. To move new records from SAP ECC tables to delta storage

E. To move deleted records from delta storage to column store

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #8

In the SAP HANA studio, which of the following enables you to identify the memory consumption of loaded tables?

A. SYS.M_TABLES

B. Load subtab of the Performance tab of the Administration editor

C. SYS.M_CS_TABLES

D. System Information tab of the Administration editor

Discussion 0

Correct Answer: B Vote an answer

Question #9

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

A. When to execute the net backup

B. The path for the backup files

C. Which backup files are obsolete

D. Whether a recovery is possible

Discussion 0

Correct Answer: C,D 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.