C_HANATEC_17 Online Practice Questions and Answers

How can the system database administrator disable tenant database functionalities? Please choose the correct answer.

A. Using the hdbuserstore tool

B. Using the resident hdblcm tool

C. Using the Manage Restricted Features app

D. Using the Manage Blacklisted Parameter app

The data storage of your productive SAP HANA instance crashed, and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss? Please choose the correct answer.

A. The last full data backup

B. The latest log backup

C. The latest incremental backup

D. The last commited transaction

Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?

Please choose the correct answer.

A. INFILE ADMIN

B. WORKLOAD ADMIN

C. DATABASE ADMIN

D. RESOURCE ADMIN

Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?

There are 2 correct answers to this question.

A. Daemon

B. Preprocessor

C. Index server

D. Compile server

Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?

There are 2 correct answers in this question.

A. The SUM folder needs to exist.

B. The source database is up and running.

C. The DMO procedure hasn't reached downtime yet.

D. A cleanup has already been triggered.

Due to a hardware failure of your persistence area, your SAP HANA database needs to be restored. Which tasks do you perform to recover the complete system? Note: There are 2 correct answers.

A. Start the recovery from the tenant database using SAP HANA cockpit 2.0

B. Recover all the databases using Initialize Log Area option

C. Recover the system database before recovering all tenant databases

D. Start the recovery from the system database SAP HANA cockpit 2.0

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. Store the logon credentials of the replayer user in the secure store.

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

C. Preprocess the captured workload on the source system.

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

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

You are setting up a disaster recovery system using system replication. You want the transaction processing of the primary system to be suspended if the network to the secondary system fails.

What log replication mode must you use?

Please choose the correct answer.

Response:

A. async

B. full sync

C. syncmem

D. sync

What are the two storage components used to restore the database in case of power failure? There are 2 correct answers to this question. Response:

A. Log area

B. Data volume

C. Memory

D. Delta store

Which activities are required when you execute an SAP HANA Near Zero Downtime upgrade? There are 2 correct answers to this question. Response:

A. Perform a takeover3.

B. Upgrade the secondary system with the command line tool.

C. Stop the secondary system.

D. Restart the primary and secondary system.