SAP Certified Associate - Database Administrator - SAP HANA (C-DBADM-2404) Free Practice Test

Question 1

How can you view the audit trail in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

A. Using the kernel profiler trace in the SAP HANA database explorer

B. Using the SQL Console in the SAP HANA database explorer

C. Using the expensive statements trace in the SAP HANA cockpit

D. Using the Auditing card in the SAP HANA cockpit

Correct Answer: B,D

Question 2

Which SAP HANA Cloud tools would you use to diagnose and analyze errors in database trace files?
Note: There are 2 correct answers to this question.

A. SAP HANA database explorer

B. SQL trace analyzer

C. SAP HANA Cloud Central

D. Full system information dump

Correct Answer: A,D

Question 3

How can the SAP HANA database minimize the risk of data loss during a power failure?

A. Data snapshots

B. Savepoints

C. Delta merges

D. Transaction logs

Correct Answer: B

Question 4

Which tools can you use to disable teriant database functionalities? Note: There are 2 correct answers to this question.

A. Manage Restricted Features

B. Manage Database Configuration

C. hdbuserstore

D. resident hdblcm

Correct Answer: B,D

Question 5

Which prerequisites must be fulfilled when recovering a tenant database? Note: There are 2 correct answers to this question.

A. The whole system must be shut down before the recovery starts.

B. The logon credentials of the <sid>adm user must be available.

C. The tenant database must be stopped before the recovery starts.

D. The logon credentials of the system database user must be available.

Correct Answer: B,C

Question 6

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

A. The_SYS_REPO technical user

B. The user who created the role

C. The DBADMIN user of the tenant database

D. The container-specific technical user

Correct Answer: D

Question 7

How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database instance?

A. In an SQL Console, execute the RECOVER DATABASE statement with the timestamp.

B. In SAP HANA Cloud Central, select the Start Recovery option and set the timestamp.

C. In the SAP HANA cockpit, select the Start Recovery option and set the timestamp.

D. In an SAP BTP CLI, execute the RECOVER DATABASE command with the timestamp.

Correct Answer: B

Question 8

How can you start an SAP HANA Cloud database instance using the command line?

A. cf update-service <SERVICE_INSTANCE> -c "{ "data": {"service Stopped": false}}"

B. of start <APPLICATION_NAME>

C. sapcontrol -nr <INSTANCE_NUMBER>-function StartSystem

D. alter system start database <DATABASE_NAME>

Correct Answer: C

Question 9

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

A. Replica

B. Native storage extension

C. Data lake

D. WORM device

Correct Answer: B

Welcome to TestSimulate

SAP Certified Associate - Database Administrator - SAP HANA (C-DBADM-2404) Free Practice Test