SAP C-HANATEC-17 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C-HANATEC-17
Exam Name/Title: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
Certification Provider: SAP
Corresponding Certification: SAP Certified Technology Associate

Exam Questions: 272
Updated On: May 27, 2026

Question #46

What can a user do when the backup operator system privileges is assigned?

A. Schedule backups

B. Delete backups

C. Configure backup settings

D. Perform data recovery

Discussion 0

Correct Answer: A Vote an answer

Question #47

Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? There are 3 correct answers to this question.

A. Restore the source system tenant backup to the target tenant.

B. Create a replayer user account on the target operating system.

C. Preprocess the captured workload on the source system.

D. Create a replayer user account in the target database system.

E. Store the logon credentials of the replayer user in the secure store.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question #48

What is XS?

A. A user interface

B. A native, lightweight application server

C. An optional engine to handle excessive data loads

D. A data cleansing engine

Discussion 0

Correct Answer: B Vote an answer

Question #49

Which characteristics describe an SAP HANA Multiple Database Container (MDC) System?
There are 3 correct answers to this question.

A. Database Isolation increases the isolation between tenant databases on the operating system level.

B. The name server owns information about the location of tables and table partitions in databases.

C. A Multitenant Database Container system is identified by a single System ID (SID).

D. The name server provides index server functionality for the system database.

E. Each tenant database runs its own compile server and the preprocessor server.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #50

Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?
Please choose the correct answer.

A. DATABASE ADMIN

B. RESOURCE ADMIN

C. INFILE ADMIN

D. WORKLOAD ADMIN

Discussion 0

Correct Answer: C Vote an answer

Question #51

Which connection types are allowed when you use system replication with the Active/Active option? There are 2 correct answers to this question.

A. Explicit read only on the secondary system

B. Explicit read and write on the secondary system

C. Implicit hint-based statement routing

D. Automatic round-robin statement routing

Discussion 0

Correct Answer: A,C Vote an answer

Question #52

Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? There are 2 correct answers to this question.

A. Internal communication channels with the system PKI

B. HTTPS client access using the SAP HANA Web Dispatcher

C. Client-server communication over JDBC

D. SAP HANA tenant database replication

Discussion 0

Correct Answer: C,D Vote an answer

Question #53

You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?

A. After the migration

B. After table creation

C. Before table creation

D. Before the migration

Discussion 0

Correct Answer: D Vote an answer

Question #54

Reloading column tables in this way restores the database to a fully operational state more quickly. However, it does create performance overhead, and may not be necessary in nonproductive systems, how can you deactivate the the reload feature? Please choose the correct answer.

A. Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

B. Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

C. Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true

D. Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false

Discussion 0

Correct Answer: D Vote an answer

Download Free SAP C-HANATEC-17 Demo

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