C_HANATEC_18 Exam Training Practice Tests (SAP Certified Application Associate

Question 1

Which user credentials are required when performing a database migration option (DMO) procedure to SAP HANA 2.0? Note: There are 3 correct answers to this question.

A. User DBACOCKPIT of the target tenant database B. S-user for the SAP Support Portal C. User SAP* of client 000 of the SAP system D. User DDIC of client 000 of the SAP system E. User SYSTEM of the target system database

Correct Answer: A,D,E

Question 2

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

A. Fallback snapshot B. Data snapshot C. Full database backup D. Delta database backup

Correct Answer: B,C

Question 3

Which connection type is used by default for restricted users?

A. HTTP/S B. JDBC C. OLEDB D. ODBC

Correct Answer: A

Question 4

How are savepoints triggered?
Note: There are 2 correct answers to this question.

A. By a database soft shutdown B. By performing a delta merge C. By issuing a transactional commit D. By performing a database backup

Correct Answer: A,D

Question 5

Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header?

A. hdbbackint B. hdbbackupdiag C. hdbbackupcheck D. hdbrecovercheck

Correct Answer: B

Question 6

The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions, and threads? Note: There are 2 correct answers to this question.

A. PerfTrace.py B. emergencylnfo_py C. Troubleshoot unresponsive systems D. Manage full system information dumps

Correct Answer: B,D

Question 7

Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question.

A. Update the SAP HANA database system and its components. B. Rename the SAP HANA database system. C. Extract the SAP HANA database system components. D. Uninstall the SAP HANA database system and its components

Correct Answer: A,C

Question 8

Which operating system process takes care of starting the SAP HANA database system services?

A. hdbrsutil B. hdbda emon C. sapstart D. sapstartsrv

Correct Answer: B

Question 9

Which system privilege do you need to redistribute tables across the hosts in a scale-out system?

A. data admin B. resource admin C. workload admin D. optimizer admin

Correct Answer: B

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C_HANATEC_18 Exam Practice Test