Winter Sale- Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

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

Page: 1 / 8
Total 80 questions

SAP Certified Associate - Database Administrator - SAP HANA Questions and Answers

Question 1

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

Options:

A.

End-to-end

B.

Kernel profiler

C.

SQL

D.

Performance trace

Question 2

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

Options:

A.

ATTACH DEBUGGER

B.

STRUCTUREDPRIVILEGE ADMIN

C.

CATALOG READ

D.

AUDIT OPERATOR

Question 3

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.

Options:

A.

Assign User Groups

B.

Create Role in Schema

C.

Assign to Role Group

D.

Assign LDAP Groups

E.

Create Group Admin

Question 4

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

Options:

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 adm user must be available.

D.

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

Question 5

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.

Options:

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.

Question 6

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

Options:

A.

MONITOR ADMIN

B.

SELECT on the _SYS_TELEMETRY schema

C.

CATALOG READ

D.

SELECT on the_SYS_STATISTICS schema

Question 7

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

Options:

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

Question 8

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.

Options:

A.

Replicas

B.

vCPUs

C.

Storage

D.

Memory

Question 9

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

Options:

A.

The executed statements trace

B.

Your personal stored procedures

C.

Your personal SQL scripts

D.

The SAP SQL statement collection

Question 10

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.

Options:

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.

Question 11

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.

Options:

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

Question 12

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

Options:

A.

Database table

B.

Kernel trace

C.

Linux syslog

D.

CSV text file

Question 13

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

Options:

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.

Question 14

How are savepoints triggered?

Note: There are 2 correct answers to this question.

Options:

A.

By performing a delta merge

B.

By issuing a transactional commit

C.

By a database soft shutdown

D.

By performing a database backup

Question 15

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

Options:

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

Question 16

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

Options:

A.

multidb.ini

B.

attributes.ini

C.

global.ini

D.

indexserver.ini

Question 17

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

Options:

A.

SAP HANA database

B.

SAP SQL Anywhere

C.

SAP IQ

D.

Data lake

Question 18

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

Options:

A.

SAP HANA HDBSQL

B.

SAP BTP cockpit

C.

SAP HANA Cloud Central

D.

SAP HANA cockpit

Question 19

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

Options:

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

Question 20

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

Options:

A.

Docker

B.

Kubernetes

C.

Runtime

D.

Design time

Question 21

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

Options:

A.

Alert Monitor

B.

Full System Information Dumps

C.

Troubleshoot Unresponsive System

D.

Performance Monitor

Question 22

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

Options:

A.

Time travel

B.

Single table backup

C.

Fallback snapshots

D.

Data snapshots

Question 23

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

Options:

A.

BACKUP ADMIN

B.

DATABASE ADMIN

C.

DATA ADMIN

D.

MONITOR ADMIN

Question 24

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.

Options:

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.

Page: 1 / 8
Total 80 questions