SAP Certified Associate - Database Administrator - SAP HANA (C_DBADM_2404) Free Practice Test

Question 1

Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question.

A. Views

B. Schemas

C. Procedures

D. Functions

Correct Answer: A,B

Question 2

In which situations can you resume the failed recovery of your productive SAP HANA tenant database? Note: There are 2 correct answers to this question.

A. An aborted recovery of a complete data backup

B. An aborted recovery of the catalog backup

C. An aborted recovery of a delta data backup

D. An aborted recovery of a log backup

Correct Answer: C,D

Question 3

What do you need in a multitenant database container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question.

A. The user in the source system must be associated with a user in the target database.

B. The user in the source system must have sufficient privileges in the target database.

C. The cross-tenant database communication must be explicitly activated.

D. The bidirectional communication channel must be allowed.

Correct Answer: B,C

Question 4

You want to prevent changes to system properties in tenant databases.
Which configuration file stores the blocklisted properties?

A. attributes.ini

B. multidb.ini

C. indexserver.ini

D. global.ini

Correct Answer: B

Question 5

Which types of SAP HANA Cloud instance can you provision in an SAP BTP account? Note: There are 2 correct answers to this question.

A. SAP HANA database

B. SAP SQL Anywhere

C. SAP IQ

D. Data lake

Correct Answer: A,D

Question 6

Which parameters are mandatory when using the HDBLCM tool in batch mode, to install the SAP HANA database system? Note: There are 2 correct answers to this question.

A. SAP HANA system ID (SID)

B. Password of user sapadm

C. Data and log path

D. Installation path

Correct Answer: A,B

Question 7

Which output channels can the SAP Alert Notification service for SAP BTP use for notification actions?
Note: There are 2 correct answers to this question.

A. WhatsApp

B. Slack

C. Signal

D. Microsoft Teams

Correct Answer: B,D

Question 8

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 9

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

Welcome to TestSimulate

SAP Certified Associate - Database Administrator - SAP HANA (C_DBADM_2404) Free Practice Test