SAP SAP Certifications C_HANATEC_14 Questions & Answers

• Question 131:

  You created data and log backups on the file system. Due to a hardware failure, you use the Recover

  Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database.

  From which location does the Recover Database app read the recovery information by default?

  Please choose the correct answer.

  Response:

  A. $(DIR_INSTANCE)/../global/hdb/custom/config

  B. $(DIR_INSTANCE)/backup/log

  C. $(DIR_INSTANCE)//trace

  D. $(DIR_INSTANCE)/backup/data

  Correct Answer: B

• Question 132:

  Which of the following SAP HANA license key types locks down the system when the current memory consumption of SAP HANA exceeds the licensed amount of memory?

  Choose the correct answer.

  Response:

  A. Temporary license keys

  B. Unenforced license keys

  C. Enforced license keys

  Correct Answer: C

• Question 133:

  Which of the following users are able to start and stop a distributed SAP HANA Database System There are 2 correct answers to this question. Response:

  A. SYSTEM user

  B. ADM user

  C. ROOT user

  Correct Answer: BC

• Question 134:

  Which command do you use to bring a distributed SAP HANA database system to a fully operational

  state?

  Please choose the correct answer.

  Response:

  A. HDB start

  B. startsap

  C. sapcontrol -nr -function Start

  D. sapcontrol -nr -function StartSystem

  Correct Answer: D

• Question 135:

  Which R3load mode is used during a database migration option procedure?

  Please choose the correct answer.

  Response:

  A. Pipe

  B. File

  C. Network

  D. Socket

  Correct Answer: A

• Question 136:

  In SAP HANA Architecture which of the following component can easily enhance the functionality of

  Multiple-Container System.

  Please choose the correct answer.

  Response:

  A. OS and Hardware

  B. Storage

  C. Tenant Database

  D. System Database

  Correct Answer: C

• Question 137:

  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.

  Response:

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

  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 false

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

  Correct Answer: C

• Question 138:

  Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive

  SAP HANA system.

  Which tools can you use to monitor the system alerts of the SAP HANA database from your PC?

  There are 2 correct answers to this question.

  Response:

  A. SAP HANA studio

  B. HDBSQL command line tool

  C. SAP NANA cockpit 2.0

  D. DBA Cockpit

  Correct Answer: AD

• Question 139:

  SAP HANA uses SSFS to protect the root encryption keys. These root keys protect all encryption keys

  used in the SAP HANA database from unauthorized access.

  What other two main functions of the root encryption keys?

  There are 2 correct answers to this question.

  Response:

  A. The root key used for the internal data encryption service of the database

  B. The root key used for data volume encryption

  C. The root key used for users log encryption

  D. The root key used for transactions volume encryption

  Correct Answer: AB

• Question 140:

  To ensures that the database can be restored to the most recent committed state after a restart which of

  the following Indexserver components make sure such consistency and maintain durable changes?

  Please choose the correct answer.

  Response:

  A. Storage Engine

  B. Relational Engines

  C. Disk Storage

  D. Request Processing

  Correct Answer: A