C-DBADM-2404 Exam Training Practice Tests (SAP Certified Associate - Database Administrator

Question 1

Which storage tier is used to manage rarely changing, persistent data?

A. Replica B. WORM device C. Native storage extension D. Data lake

Correct Answer: C

Question 2

When using the SAP HANA cockpit, which user credentials do you need to stop the SAP HANA database system? Note: There are 3 correct answers to this question.

A. Root B. Cockpit User C. <sid>adm D. sap<sid> E. Database User

Correct Answer: B,C,E

Question 3

Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol (LDAP) server? Note: There are 2 correct answers to this question.

A. User group assignment B. User creation C. Role assignment D. Password policy configuration

Correct Answer: B,C

Question 4

What possibilities do you have when upgrading an SAP HANA Cloud, SAP HANA database instance?
Note: There are 2 correct answers to this question.

A. Revert to a previous version B. Upgrade the replica first C. install Upgrade without restart D. Select the version to

Correct Answer: C,D

Question 5

What happens when you rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question.

A. The tenant database is unloaded from memory. B. The tenant database is stopped. C. The tenant database backups are renamed. D. The tenant database trace directory is renamed.

Correct Answer: B,D

Question 6

When performing a standard SAP HANA database system installation, which users will be created or validated by default during that installation? Note: There are 3 correct answers to this question.

A. SAP<SID> B. <sid>crypt C. SYSTEM D. syb<sid> E. sapadm

Correct Answer: B,C,E

Question 7

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 8

Who owns all database objects deployed using the SAP HANA Deployment Infrastructure (HDI)?

A. The container-specific technical user B. The_SYS_REPO technical user C. The user who created the role D. The DBADMIN user of the tenant database

Correct Answer: A

Question 9

What attributes can you control when creating an SAP HANA Cloud, data lake instance? Note: There are 3 correct answers to this question.

A. Availability zone B. Automatic backup creation C. Compatibility with SAP IQ D. Number of coordinators E. Compatibility with Apache Hadoop

Correct Answer: A,C,D

SAP Certified Associate - Database Administrator - SAP HANA - C-DBADM-2404 Exam Practice Test