C_DBADM_2404

Monitoring and Troubleshooting

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

Answer A D

Monitoring and Troubleshooting

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

Answer C

Monitoring and Troubleshooting

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

Answer B
C_DBADM_2404

Monitoring and Troubleshooting

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

Answer A C E

Monitoring and Troubleshooting

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

Answer C D

Monitoring and Troubleshooting

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

Answer C D E
C_DBADM_2404

Monitoring and Troubleshooting

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

Answer A D

Monitoring and Troubleshooting

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

Answer A D E

Monitoring and Troubleshooting

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

Answer A B
C_DBADM_2404

Monitoring and Troubleshooting

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

Answer C D

Monitoring and Troubleshooting

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

Answer A B

Monitoring and Troubleshooting

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

Answer C D
C_DBADM_2404

Monitoring and Troubleshooting

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

Answer B C

Monitoring and Troubleshooting

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

Answer A

Database Security

Question 15

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

A. 1
B. 3
C. 2
D. 4

Answer C
C_DBADM_2404

Database Security

Question 16

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 have sufficient privileges in the target database.
B. The cross-tenant database communication must be explicitly activated.
C. The user in the source system must be associated with a user in the target database.
D. The bidirectional communication channel must be allowed.

Answer A B

Database Security

Question 17

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 expensive statements trace in the SAP HANA cockpit

B. Using the Auditing card in the SAP HANA cockpit
C. Using the SQL Console in the SAP HANA database explorer
D. Using the kernel profiler trace in the SAP HANA database explorer

Answer B C

Database Security

Question 18

Which options for Audited Action Status are available in the SAP HANA Cloud, SAP HANA database?
Note: There are 2 correct answers to this question.

A. Critical
B. Enabled
C. All
D. Unsuccessful

Answer C D
C_DBADM_2404

Database Security

Question 19

Which audit trail target is used by default in the SAP HANA Cloud, SAP HANA database?

A. Database table
B. Kernel trace
C. Linux syslog
D. CSV text file

Answer A

Database Security

Question 20

What is the default single sign-on method when using hdbsql?

A. Token based
B. SAML based
C. Kerberos based
D. Certificate based

Answer B

Database Security

Question 21

Which container types are available in SAP HANA Deployment Infrastructure (HDI)? Note: There are
2 correct answers to this question.

A. Docker
B. Kubernetes
C. Runtime
D. Design time

Answer C D
C_DBADM_2404

Database Security

Question 22

Which SAP HANA security tasks can be performed in combination with a Lightweight
Directory Access Protocol (LDAP) server? Note: There are 2 correct answers to this question.

A. User group assignment

B. User creation
C. Password policy configuration
D. Role assignment

Answer B D

Database Security

Question 23

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

A. The user who created the role

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

Answer D

Database Security

Question 24

What cryptographic libraries are supported in SAP HANA? Note: There are 2 correct answers to
this question.

A. CommonCryptoLib
B. Libgcrypt
C. OpenSSL
D. LibreSSL

Answer A C
C_DBADM_2404

SAP HANA Architecture

Question 25

How are savepoints triggered?

Note: There are 2 correct answers to this question.

A. By performing a delta merge

B. By issuing a transactional commit
C. By a database soft shutdown
D. By performing a database backup

Answer C D

SAP HANA Architecture

Question 26

Which hardware KPIs do you need to size before performing a tailored data center integration (TDI)
installation for a productive SAP HANA database system? Note: There are 2 correct answers to this
question.

A. DRAM required for the static data memory area

B. Total disk space required for the log volume
C. Persistent memory (PMEM) required for backups
D. Network bandwidth for the storage zone

Answer A B

SAP HANA Architecture

Question 27

In which scenario do you need SAP expert sizing?

Note: There are 2 correct answers to this question.

A. Migrating existing SAP ERP systems from AnyDB to run on SAP HANA
B. Customer is new to SAP ERP applications and the SAP HANA database system
C. Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA
D. Carving out SAP ERP functionality from the source system to the SAP ERP system on
SAP HANA

Answer C D
C_DBADM_2404

SAP HANA Architecture

Question 28

Which database storage technology does native storage extension utilize in SAP HANA Cloud?

A. Dynamic tiering
B. Disk-based
C. In-memory
D. Extension node

Answer B

SAP HANA Architecture

Question 29

What possibilities do you have when upgrading an SAP HANA Cloud, SAP HANA database instance?
Note: There are 2 correct answers to this question.

A. Upgrade the replica first

B. Select the version to
C. install Upgrade without restart
D. Revert to a previous version

Answer B C

SAP HANA Architecture

Question 30

Where does the SAP HANA Cloud, SAP HANA database run in SAP BTP?

A. Kubernetes container
B. SAP HANA Cloud Central
C. Cloud Foundry runtime
D. Kyma runtime

Answer A
C_DBADM_2404

SAP HANA Architecture

Question 31

Which object types are stored in an SAP HANA catalog? Note: There are 3 correct answers to this
question.

A. Cubes
B. HDI containers
C. Agents
D. Cockpit roles
E. JSON collections

Answer A C E

SAP HANA Architecture

Question 32

In SAP HANA Cloud, which tasks are handled by the cloud provider?

Note: There are 3 correct answers to this question.

A. Tuning the database to run optimally on the underlying operating system and hardware
B. Backing up the operating system and the database software
C. Installing, configuring, and upgrading the operating system
D. Sizing, provisioning, and monitoring the database
E. Managing users, roles, and permissions in the database

Answer A B C

SAP HANA Architecture

Question 33

Youch services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app? To
ve: There are 2 correct answers to this question.

A. Web dispatcher
B. Index server
C. XS engine
D. Compile server

Answer B
C_DBADM_2404

SAP HANA Architecture

Question 34

A new version of SAP HANA Cloud, SAP HANA database is available as of today.

If you do NOT perform the upgrade manually, how much time do you have before your database will
be automatically upgraded to the next version?

A. 2 weeks
B. 3 months
C. 1 year
D. 7 months

Answer D

SAP HANA Architecture

Question 35

Which file systems are supported for the data and log volumes of the SAP HANA 2.0
database system? Note: There are 2 correct answers to this question.

A. XFS
B. Btrfs
C. GPFS
D. EXT4

Answer A C

SAP HANA Architecture

Question 36

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

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

Answer C
C_DBADM_2404

User Management

Question 37

What is the only assignable privilege for the Privileges on Users type?

A. ATTACH DEBUGGER
B. STRUCTUREDPRIVILEGE ADMIN
C. CATALOG READ
D. AUDIT OPERATOR

Answer A

User Management

Question 38

Which system privileges are required for administering tenant databases when connected to
the system database? Note: There are 2 correct answers to this question.

A. BACKUP ADMIN
B. DATABASE ADMIN
C. DATA ADMIN
D. MONITOR ADMIN

Answer A B

User Management

Question 39

You want to change a standard user account into a restricted user account. Which attributes do you
need to adjust?

Note: There are 3 correct answers to this question.

A. Disable ODBC/JDBC Access must be set to "Yes".

B. Authorization method must be set to "LDAP".
C. Creation of Objects in Own Schema must be set to "No".
D. User Group must be set to "Restricted".
E. PUBLIC role must be set to "No".

Answer C D E
C_DBADM_2404

User Management

Question 40

Which options can you use when creating a role in the SAP HANA Cloud, SAP HANA database? Note:
There are 3 correct answers to this question.

A. Assign User Groups

B. Create Role in Schema
C. Assign to Role Group
D. Assign LDAP Groups
E. Create Group Admin

Answer B C E

User Management

Question 41

Which privilege types are available in SAP HANA Cloud?

Note: There are 3 correct answers to this question.

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

Answer A B C

User Management

Question 42

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. Functions
B. Views
C. Procedures
D. Schemas

Answer B D
C_DBADM_2404

User Management

Question 43

What can you assign to a user with the User Management app in the SAP HANA cockpit? Note: There
are 2 correct answers to this question.

A. LDAP identity provider

B. Scopes
C. LDAP authorization mode
D. User group

Answer C D

User Management

Question 44

What can you assign to a user group in the SAP HANA Cloud, SAP HANA database? Note: There are
2 correct answers to this question.

A. Password policies
B. Users
C. Permissions
D. Roles

Answer A B

User Management

Question 45

Which privileges are required to create the COCKPIT MONITOR technical user? Note: There are
2 correct answers to this question.

A. MONITOR ADMIN
B. SELECT on the _SYS_TELEMETRY schema
C. CATALOG READ
D. SELECT on the_SYS_STATISTICS schema

Answer C D
C_DBADM_2404

User Management

Question 46

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

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

Answer B

Database Administration

Question 47

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

A. multidb.ini
B. attributes.ini
C. global.ini
D. indexserver.ini

Answer A

Database Administration

Question 48

Which actions can you perform on an SAP HANA Cloud, SAP HANA database using the Cloud
Foundry CLI? Note: There are 2 correct answers to this question.

A. Recover instance
B. Change instance backup schedule
C. Decrease data volume size
D. Create instance

Answer A D
C_DBADM_2404

Database Administration

Question 49

You want to use the multi-environment database administration tools to administer an SAP HANA
Cloud, SAP HANA database instance. Which SAP BTP entitlement service plans do you need?

Note: There are 2 correct answers to this question.

A. hana
B. relational data lake
C. multi-environment tools
D. tools

Answer A D

Database Administration

Question 50

Which tool do you use to execute SQL queries on the SAP HANA Cloud database?

A. SQLScript
B. SQL Console
C. HDBSQL
D. SQL Editor

Answer B

Database Administration

Question 51

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

A. alter system start database <DATABASE_NAME>

B. cf update-service <SERVICE_INSTANCE> -c "{ "data": {"service Stopped": false}}"
C. sapcontrol -nr <INSTANCE_NUMBER>-function StartSystem
D. of start <APPLICATION_NAME>

Answer C
C_DBADM_2404

Database Administration

Question 52

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

A. resident hdblcm
B. Manage Database Configuration
C. hdbuserstore
D. Manage Restricted Features

Answer A B

Database Administration

Question 53

Which system privilege must you have to restrict features for tenant databases in the SAP HANA
cockpit?

A. INIFILE ADMIN
B. RESOURCE ADMIN
C. SERVICE ADMIN
D. DATABASE ADMIN

Answer A

Database Administration

Question 54

Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?
Note: There are 2 correct answers to this question.

A. Web dispatcher
B. Index server
C. XS engine
D. Compile server

Answer A D
C_DBADM_2404

Database Administration

Question 55

When using the SAP HANA cockpit, which user credentials do you need to stop the SAP HANA
database system? Note: There are 3 correct answers to this question.

A. Cockpit User
B. sap<sid>
C. Database User
D. Root
E. <sid>adm

Answer A C E

Database Administration

Question 56

Where can you start/stop an SAP HANA Cloud, SAP HANA database?

A. SAP HANA HDBSQL

B. SAP BTP cockpit
C. SAP HANA Cloud Central
D. SAP HANA cockpit

Answer C

Database Administration

Question 57

From which sources can you import catalog objects when using the SAP HANA database explorer?
Note: There are 3 correct answers to this question.

A. Data lake files

B. Local computer
C. Google Cloud Storage
D. HPE GreenLake
E. IBM public cloud

Answer A B C
C_DBADM_2404

Database Administration

Question 58

What happens when you rename a tenant database in the SAP HANA cockpit? Note: There are 2
correct answers to this question.

A. The tenant database is stopped.

B. The tenant database backups are renamed.
C. The tenant database trace directory is renamed.
D. The tenant database is unloaded from memory.

Answer A C

Database Administration

Question 59

Which role do you need in order to assign users to groups in the SAP HANA cockpit?

A. Cockpit Administrator role

B. Cockpit Database Administrator role
C. Cockpit User Administrator rolle
D. Cockpit User role

Answer

Provisioning SAP HANA

Question 60

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

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

Answer A
C_DBADM_2404

Provisioning SAP HANA

Question 61

Which actions can you only choose when using the resident HDBLCM tool as root user? Note:
There are 2 correct answers to this question.

A. rename_system
B. unregister_system
C. update_host
D. configure_internal_network

Answer A B

Provisioning SAP HANA

Question 62

You are using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation
media. Which tasks can you perform from the command line?

Note: There are 2 correct answers to this question.

A. Update the SAP HANA database system and its components.

B. Rename the SAP HANA database system.
C. Uninstall the SAP HANA database system and its components.
D. Extract the SAP HANA database system components.

Answer A D

Provisioning SAP HANA

Question 63

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

Answer A D
C_DBADM_2404

Provisioning SAP HANA

Question 64

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

Answer A B

Provisioning SAP HANA

Question 65

Which data stores are activated by default when you provision an SAP HANA Cloud, SAP HANA
database? Note: There are 2 correct answers to this question.

A. Native storage extension

B. In-memory
C. Data lake
D. Hadoop distributed file system

Answer A B

Provisioning SAP HANA

Question 66

What attributes can you control when creating an SAP HANA Cloud, data lake instance? Note: There
are 3 correct answers to this question.

A. Automatic backup creation

B. Availability zone
C. Number of coordinators
D. Compatibility with SAP IQ
E. Compatibility with Apache Hadoop

Answer B C D
C_DBADM_2404

Provisioning SAP HANA

Question 67

Which resources will be changed when you scale down an SAP HANA Cloud, SAP HANA database
instance? Note: There are 2 correct answers to this question.

A. Replicas
B. vCPUs
C. Storage
D. Memory

Answer B D

Provisioning SAP HANA

Question 68

What options do you have when deploying an SAP HANA Cloud, SAP HANA database with an
integrated data lake? Note: There are 2 correct answers to this question.

A. Create an SAP HANA Cloud database with a separate data lake.

B. Create an SAP HANA Cloud database with the data lake on premise.
C. Create an SAP HANA Cloud database and later add a data lake.
D. Create an SAP HANA Cloud database and include a data lake in one step.

Answer C D

Provisioning SAP HANA

Question 69

When performing a standard SAP HANA database system installation, which users will be created
or validated by default during that installation? Note: There are 3 correct answers to this question.

A. SYSTEM
B. syb<sid>
C. SAP<SID>
D. sapadm
E. <sid>crypt

Answer A D E
C_DBADM_2404

Backup and Recovery

Question 70

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

A. Full back up, differential backup, log backup

B. Incremental backup, log backup
C. Full back up, log backup
D. Full back up, incremental backup, log backup

Answer D

Backup and Recovery

Question 71

What is one of the backup options provided by the SAP HANA database?

A. Time travel
B. Single table backup
C. Fallback snapshots
D. Data snapshots

Answer D

Backup and Recovery

Question 72

How can you ensure that a consistent database status is saved using data snapshots?

A. Execute the hdbbackupdiag tool.

B. Create a fallback snapshot.
C. Create an internal database snapshot.
D. Trigger a savepoint.

Answer C
C_DBADM_2404

Backup and Recovery

Question 73

How long are SAP HANA Cloud, SAP HANA database backups retained by default?

A. 3 weeks
B. 2 weeks
C. 1 week
D. 4 weeks

Answer B

Backup and Recovery

Question 74

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

Answer C

Backup and Recovery

Question 75

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

A. hdbrecovercheck
B. recoverSys.py
C. hdbmdcutil
D. RecoverUtil.py

Answer B
C_DBADM_2404

Backup and Recovery

Question 76

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 an SAP BTP CLI, execute the RECOVER DATABASE command with the timestamp.
D. In the SAP HANA cockpit, select the Start Recovery option and set the timestamp.

Answer B

Backup and Recovery

Question 77

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. Data snapshot
B. Incremental backup
C. Complete backup
D. Log backup
E. Differential backup

Answer B C E

Backup and Recovery

Question 78

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 delta data backup

B. An aborted recovery of a log backup
C. An aborted recovery of a complete data backup
D. An aborted recovery of the catalog backup

Answer A B
C_DBADM_2404

Backup and Recovery

Question 79

Which scenarios are supported for a database copy using backup and recovery from a source
machine to a target machine? Note: There are 2 correct answers to this question.

A. The source system has more nodes than the target system.
B. The source system and target system have different SIDS.
C. The source system and target system have different CPU architecture.
D. The source system release version is higher than the target system.

Answer B C

Backup and Recovery

Question 80

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

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

B. The logon credentials of the system database user must be available.
C. The logon credentials of the <sid>adm user must be available.
D. The whole system must be shut down before the recovery starts.

Answer A C