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

On which of the following operating systems is installation of the SAP HANA client supported? Note: There are 3 correct answers

A. Microsoft Windows

B. z/OS

C. OSX

D. AIX

E. Solaris

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #11

Which of the following tasks can you perform only with system privilege TRACE ADMIN? (Choose two)

A. Delete SYS.P_SQLSCRIPTTRACE_.

B. Start a Python

C. Start SQL traces

D. Delete trace files

Discussion 0

Correct Answer: C,D Vote an answer

Question #12

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

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

For what purpose do you visualize a query plan?

A. To investigate which engines are executing an SQL query

B. To analyze query results

C. To update SAP HANA database statistics

D. To generate a new execution plan on SQL queries

Discussion 0

Correct Answer: A Vote an answer

Question #15

Which of the following allow you to reset the peak used memory? (Choose two)

A. Administration editor -> Landscape -> Services -> Reset Memory Statistics from the context menu.

B. ALTER SYSTEM RESET MONITOERING VIEW SYS.M HEAP_MEMORY_RESET.

C. ALTER SYSTEM RESET MONITOERING VIEW SYS.M_DATA_VOLUMES.

D. Administration editor -> System Information -> Component memory usage.

Discussion 0

Correct Answer: A,B Vote an answer

Question #16

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

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

What information about a column store table can you fine in the Open Definition report? (Choose two).

A. The columns that are loaded into memory

B. The source system that populates the table

C. The time and data of the last backup of the table

D. The compression rate of columns

Discussion 0

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