C_DBADM_2404

Welcome to your C_DBADM_2404

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.

EXT4

GPFS

Btrfs

XFS

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

INIFILE ADMIN

DATABASE ADMIN

SERVICE ADMIN

RESOURCE ADMIN

None

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

SAP SQL Anywhere

Data lake

SAP HANA database

SAP IQ

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.

Storage

Memory

Replicas

vCPUs

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

Schemas

Views

Procedures

Functions

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.

An aborted recovery of a delta data backup

An aborted recovery of a complete data backup

An aborted recovery of a log backup

An aborted recovery of the catalog backup

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

OpenSSL

CommonCryptoLib

LibreSSL

Libgcrypt

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

NUMA memory bandwidth test

CPU states

Cloud connector status

Linux kernel information

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

Incremental backup

Data snapshot

Complete backup

Log backup

Differential backup

10.

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

Compile server

DP server

DI server

Name server

11.

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

Object

Package

Analytic

Application

System

12.

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

Local computer

Data lake files

IBM public cloud

Google Cloud Storage

HPE GreenLake

13.

In which scenario do you need SAP expert sizing? Note: There are 2 correct answers to this question.

Carving out SAP ERP functionality from the source system to the SAP ERP system on SAP HANA

Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA

Migrating existing SAP ERP systems from AnyDB to run on SAP HANA

Customer is new to SAP ERP applications and the SAP HANA database system

14.

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.

Index server

Web dispatcher

Compile server

XS engine

15.

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

recoverSys.py

hdbrecovercheck

hdbmdcutil

RecoverUtil.py

None

16.

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.

Critical

All

Enabled

Unsuccessful

17.

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

Agents

Cubes

HDI containers

JSON collections

Cockpit roles

18.

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.

Rename the SAP HANA database system.

Update the SAP HANA database system and its components.

Extract the SAP HANA database system components.

Uninstall the SAP HANA database system and its components.

19.

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

Disk-based

Extension node

In-memory

Dynamic tiering

None

20.

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

The DBADMIN user of the tenant database

The container-specific technical user

The user who created the role

The_SYS_REPO technical user

None

21.

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.

Create Group Admin

Assign to Role Group

Create Role in Schema

Assign LDAP Groups

Assign User Groups

22.

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

Cockpit User Administrator rolle

Cockpit Database Administrator role

Cockpit Administrator role

Cockpit User role

None

23.

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

SYS.M DATABASE

SYS.M_WORKLOAD

SYS.M_SERVICES

SYS.M_SERVICE_STATISTICS

SYS.M_LOAD_HISTORY_HOST

24.

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

STRUCTUREDPRIVILEGE ADMIN

ATTACH DEBUGGER

CATALOG READ

AUDIT OPERATOR

None

25.

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.

LDAP identity provider

LDAP authorization mode

Scopes

User group

26.

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

hdbuserstore

resident hdblcm

Manage Database Configuration

Manage Restricted Features

27.

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

SAP BTP cockpit

SAP HANA Cloud Central

SAP HANA database explorer

SAP HANA cockpit

28.

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.

Installation path

SAP HANA system ID (SID)

Password of user sapadm

Data and log path

29.

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

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

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

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

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

30.

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

MONITOR ADMIN

SELECT on the _SYS_TELEMETRY schema

CATALOG READ

SELECT on the_SYS_STATISTICS schema

31.

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.

User Group must be set to "Restricted".

PUBLIC role must be set to "No".

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

Authorization method must be set to "LDAP".

Creation of Objects in Own Schema must be set to "No".

32.

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

update_host

configure_internal_network

rename_system

unregister_system

33.

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

SAP HANA Cloud Central

SAP HANA HDBSQL

SAP HANA cockpit

SAP BTP cockpit

None

34.

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.

Database User

adm

Root

Cockpit User

sap

35.

How are savepoints triggered? Note: There are 2 correct answers to this question.

By performing a database backup

By a database soft shutdown

By performing a delta merge

By issuing a transactional commit

36.

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

BACKUP ADMIN

DATA ADMIN

DATABASE ADMIN

MONITOR ADMIN

37.

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

1 week

2 weeks

3 weeks

4 weeks

38.

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

HDLADMIN

SYSTEM

COCKPIT MONITOR

DBADMIN

None

39.

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.

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

Create an SAP HANA Cloud database and later add a data lake.

Create an SAP HANA Cloud database with the data lake on premise.

Create an SAP HANA Cloud database and include a data lake in one step.

40.

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

of start

sapcontrol -nr -function StartSystem

alter system start database

cf update-service -c "{ "data": {"service Stopped": false}}"

None

41.

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.

SYSTEM

crypt

syb

sapadm

SAP

42.

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

The tenant database is unloaded from memory.

The tenant database backups are renamed.

The tenant database trace directory is renamed.

The tenant database is stopped.

43.

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.

HTML file

JSON file

CSV file

XML file

TXT file

44.

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

Native storage extension

Replica

Data lake

WORM device

None

45.

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

Your personal stored procedures

The SAP SQL statement collection

The executed statements trace

Your personal SQL scripts

46.

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.

SAP HANA Cloud Central

SAP HANA database explorer

Full system information dump

SQL trace analyzer

47.

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.

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

The bidirectional communication channel must be allowed.

The cross-tenant database communication must be explicitly activated.

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

48.

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.

Compile server

XS engine

Index server

Web dispatcher

49.

In SAP HANA Cloud, which tasks are handled by the cloud provider? Note: There are 3 correct answers to this question.

Backing up the operating system and the database software

Sizing, provisioning, and monitoring the database

Tuning the database to run optimally on the underlying operating system and hardware

Installing, configuring, and upgrading the operating system

Managing users, roles, and permissions in the database

50.

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

The category

The proposed solution

The schedule

The interval settings

The thresholds

51.

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

Runtime

Docker

Design time

Kubernetes

52.

How can you view the audit trail in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

Using the kernel profiler trace in the SAP HANA database explorer

Using the SQL Console in the SAP HANA database explorer

Using the Auditing card in the SAP HANA cockpit

Using the expensive statements trace in the SAP HANA cockpit

53.

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

Linux syslog

CSV text file

Kernel trace

Database table

None

54.

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

HDBSQL

SQLScript

SQL Console

SQL Editor

None

55.

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

Compatibility with Apache Hadoop

Automatic backup creation

Number of coordinators

Availability zone

Compatibility with SAP IQ

56.

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

To execute scripts from the SQL statement collection for SAP HANA

To share custom SQL scripts with the whole administration team

To determine special database information not available in the SAP HANA cockpit

To collect all the executed SQL statements and generate a searchable library list

57.

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

NUMA memory bandwidth test

CPU states

Cloud connector status

Linux kernel information

58.

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.

Users

Password policies

Permissions

Roles

59.

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

Trigger a savepoint.

Create an internal database snapshot.

Create a fallback snapshot.

Execute the hdbbackupdiag tool.

60.

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.

User group assignment

Role assignment

Password policy configuration

User creation

61.

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

None

62.

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

Fallback snapshots

Single table backup

Data snapshots

Time travel

63.

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

Revert to a previous version

Select the version to

Upgrade the replica first

install Upgrade without restart

64.

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

Full System Information Dumps

Performance Monitor

Alert Monitor

Troubleshoot Unresponsive System

None

65.

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.

multi-environment tools

relational data lake

tools

hana

66.

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

Cloud Foundry CLI

Start Recovery wizard

Service Plan Assignment editor

Manage Configuration editor

67.

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.

Total disk space required for the log volume

Network bandwidth for the storage zone

Persistent memory (PMEM) required for backups

DRAM required for the static data memory area

68.

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

Kyma runtime

Kubernetes container

Cloud Foundry runtime

SAP HANA Cloud Central

69.

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

DBADMIN

SAPSA

DBA

HDLADMIN

70.

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.

The source system release version is higher than the target system.

The source system has more nodes than the target system.

The source system and target system have different CPU architecture.

The source system and target system have different SIDS.

71.

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.

Data lake

In-memory

Native storage extension

Hadoop distributed file system

72.

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.

Recover instance

Create instance

Change instance backup schedule

Decrease data volume size

73.

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

Kernel profiler

End-to-end

Performance trace

SQL

None

74.

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

Token based

Certificate based

Kerberos based

SAML based

None

75.

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

multidb.ini

global.ini

attributes.ini

indexserver.ini

None

76.

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

Full back up, differential backup, log backup

Full back up, log backup

Full back up, incremental backup, log backup

Incremental backup, log backup

None

77.

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.

Slack

Microsoft Teams

Signal

78.

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?

3 months

2 weeks

7 months

1 year

None

79.

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

Admission control

Workload classes

Workload analysis

Load unit configuration

None

80.

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

The whole system must be shut down before the recovery starts.

The logon credentials of the system database user must be available.

The logon credentials of the adm user must be available.

The tenant database must be stopped before the recovery starts.

Time's up