SAP C_DBADM_2404 Exam Practice Test Instant Access

Question 1

Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note: There are 3 correct answers to this question.

AData snapshot

BIncremental backup

CComplete backup

DLog backup

EDifferential backup

Answer : B, C, E

Question 2

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

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

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

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

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

Answer : B

Question 3

Which tool do you use to reinitialize a non-recoverable system database?

Ahdbrecovercheck

BrecoverSys.py

Chdbmdcutil

DRecoverUtil.py

Answer : B

Question 4

You want to implement a 28-day backup cycle. Which scenario uses the least storage?

AFull back up, differential backup, log backup

BIncremental backup, log backup

CFull back up, log backup

DFull back up, incremental backup, log backup

Answer : D

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.

ASAP HANA database

BSAP SQL Anywhere

CSAP IQ

DData lake

Answer : A, D

Question 6

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

AFunctions

BViews

CProcedures

DSchemas

Answer : B, D

Question 7

Which privilege types are available in SAP HANA Cloud? Note: There are 3 correct answers to this question.

AAnalytic

BSystem

CObject

DApplication

EPackage

Answer : A, B, C

SAP C_DBADM_2404 SAP Certified Associate - Database Administrator - SAP HANA Exam Practice Test