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: Sep 30, 2026

Question #23

Which actions are always recorded when auditing is active? Note: There are 2 correct answers.

A. Grant or revoke user

B. Disable auditing

C. Create or drop user

D. Modification of an audit policy

Discussion 0

Correct Answer: B,D Vote an answer

Question #24

How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

A. Set up cross-database access control

B. Edit the configuration change blacklist

C. Assign internal communication ports

D. Set database isolation levels to high

Discussion 0

Correct Answer: B Vote an answer

Question #25

What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer.

A. Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.

B. Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.

C. Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded.

D. Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.

E. Aborted transactions are rolled back.

Discussion 0

Correct Answer: D Vote an answer

Question #26

Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There are 2 correct answers to this question.

A. User mapping

B. Bi-directional communication channels

C. User sharing

D. Communication channel whitelist

Discussion 0

Correct Answer: A,D Vote an answer

Question #27

You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace? There are 2 correct answers to this question.

A. Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.

B. Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.

C. Specify the user as the database user.

D. Specify the name of the table/view.

Discussion 0

Correct Answer: A,C Vote an answer

Question #28

Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

A. STANDBY

B. MASTER 1

C. WORKER

D. SLAVE

Discussion 0

Correct Answer: A,C Vote an answer

Question #29

Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question.

A. Validation of the LPAR configuration settings on IBM Power servers

B. Validation of the operating system configuration settings for the Linux kernel

C. Measurement of the data throughput between CPU and DRAM

D. Measurement of data throughput between the Linux kernel and CPU

E. Measurement of data throughput between SAP HANA nodes and storage

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #30

Which backup and recovery scenario is allowed in multitenant database containers?

A. The system database should be recovered first in order to recover the tenant databases.

B. After the recovery of a tenant database, the system database needs a backup.

C. A tenant database can initiate its own backup, but the system database executes the recovery.

D. A backup of a tenant database can be recovered to the system database.

Discussion 0

Correct Answer: C Vote an answer

Question #31

Which types of backup can you use to copy an SAP HANA tenant database?
There are 2 correct answers to this question.

A. Data snapshot

B. Delta database backup

C. Fallback snapshot

D. Full database backup

Discussion 0

Correct Answer: A,D Vote an answer

Question #32

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

How can you minimize the database migration option (DMO) downtime?

A. Provide the measured table migration duration for table sequencing during benchmarking

B. Adjust the number of R3load processes during benchmarking and the DMO procedure

C. Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes

D. Use the benchmarking tool for a productive database migration with the DMO procedure

Discussion 0

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