SAP Certified Associate - Database Administrator - SAP HANA

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

A. Package B. Analytic C. Object D. Application E. System

Correct Answer: B,C,E

QUESTION NO: 2
Which SAP HANA trace must you activate to analyze performance issues with systems where third- party software cannot be installed?

A. Performance trace B. Kernel profiler C. SQL D. End-to-end

Correct Answer: B

QUESTION NO: 3
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 SQL Console in the SAP HANA database explorer B. Using the Auditing card in the SAP HANA cockpit C. Using the expensive statements trace in the SAP HANA cockpit D. Using the kernel profiler trace in the SAP HANA database explorer

Correct Answer: A,B

QUESTION NO: 4
Which user is automatically created when you add a data lake to an SAP HANA Cloud, SAP HANA database?

A. SAPSA B. DBADMIN C. DBA D. HDLADMIN

Correct Answer: D

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

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

Correct Answer: A

QUESTION NO: 6
Which storage tier is used to manage rarely changing, persistent data?

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

Correct Answer: A

QUESTION NO: 7
Which user is assigned by default when you provision a data lake in SAP HANA Cloud?

A. DBADMIN B. SYSTEM C. HDLADMIN D. COCKPIT MONITOR

Correct Answer: A

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

A. Incremental backup B. Data snapshot C. Complete backup D. Differential backup E. Log backup

Correct Answer: A,C,D

QUESTION NO: 9
What is the purpose of the statement library in the SAP HANA database explorer? Note: There are 2 correct answers to this question.

A. To determine special database information not available in the SAP HANA cockpit B. To collect all the executed SQL statements and generate a searchable library list C. To execute scripts from the SQL statement collection for SAP HANA D. To share custom SQL scripts with the whole administration team

Correct Answer: A,C

SAP Certified Associate - Database Administrator - SAP HANA - C_DBADM_2404 Exam Questions