SAP c-dbadm-2404 practice test

SAP Certified Associate - Database Administrator - SAP HANA

Last exam update: Nov 18 ,2025
Page 1 out of 6. Viewing questions 1-15 out of 80

Question 1

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. SAP HANA Cloud Central
  • C. SQL trace analyzer
  • D. Full system information dump
Mark Question:
Answer:

A D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

Which SAP HANA cockpit application can you use to investigate a system offline situation?

  • A. Alert Monitor
  • B. Full System Information Dumps
  • C. Troubleshoot Unresponsive System
  • D. Performance Monitor
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

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

  • A. End-to-end
  • B. Kernel profiler
  • C. SQL
  • D. Performance trace
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

You want to compare and analyze session-specific data.In what format can you save data sets from
the SAP HANA cockpit sessions app? Note: There are 3 correct answers to this question.

  • A. HTML file
  • B. XML file
  • C. TXT file
  • D. JSON file
  • E. CSV file
Mark Question:
Answer:

A C E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 5

What can you store in the statement library? Note: There are 2 correct answers to this question.

  • A. The executed statements trace
  • B. Your personal stored procedures
  • C. Your personal SQL scripts
  • D. The SAP SQL statement collection
Mark Question:
Answer:

C D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

From which system views can you export content when using the Performance Monitor app? Note:
There are 3 correct answers to this question.

  • A. SYS.M_WORKLOAD
  • B. SYS.M_SERVICE_STATISTICS
  • C. SYS.M_LOAD_HISTORY_HOST
  • D. SYS.M_SERVICES
  • E. SYS.M DATABASE
Mark Question:
Answer:

C D E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 7

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 execute scripts from the SQL statement collection for SAP HANA
  • B. To collect all the executed SQL statements and generate a searchable library list
  • C. To share custom SQL scripts with the whole administration team
  • D. To determine special database information not available in the SAP HANA cockpit
Mark Question:
Answer:

A D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Which properties can you change in the Alert Definitions app? Note: There are 3 correct answers to
this question.

  • A. The interval settings
  • B. The proposed solution
  • C. The category
  • D. The schedule
  • E. The thresholds
Mark Question:
Answer:

A D E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 9

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. Slack
  • B. Microsoft Teams
  • C. WhatsApp
  • D. Signal
Mark Question:
Answer:

A B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

What tools can you use to view the expensive statement trace file? Note: There are 2 correct answers
to this question.

  • A. SAP HANA Cloud Central
  • B. SAP BTP cockpit
  • C. SAP HANA cockpit
  • D. SAP HANA database explorer
Mark Question:
Answer:

C D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

Which services are shared in the Manage Services app in the SAP HANA Cloud database? Note: There
are 2 correct answers to this question.

  • A. Compile server
  • B. Name server
  • C. DP server
  • D. DI server
Mark Question:
Answer:

A B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

What can you check with the SAP HANA hardware and cloud measurement tool (HCMT)? Note: There
are 2 correct answers to this question.

  • A. Linux kernel information
  • B. Cloud connector status
  • C. CPU states
  • D. NUMA memory bandwidth test
Mark Question:
Answer:

C D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

Which tools are available in SAP HANA Cloud Central? Note: There are 2 correct answers to this
question.

  • A. Service Plan Assignment editor
  • B. Start Recovery wizard
  • C. Manage Configuration editor
  • D. Cloud Foundry CLI
Mark Question:
Answer:

B C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

Which feature do you use to dynamically control SAP HANA database workloads per client session?

  • A. Workload classes
  • B. Workload analysis
  • C. Admission control
  • D. Load unit configuration
Mark Question:
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

What is the maximum number of replicas you can configure for SAP HANA Cloud?

  • A. 1
  • B. 3
  • C. 2
  • D. 4
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2