[2024] Pass SAP C_DBADM_2404 Test Practice Test Questions Exam Dumps [Q17-Q38]

admin C_DBADM_2404 SAP September 21, 2024

Rate this post

[2024] Pass SAP C_DBADM_2404 Test Practice Test Questions Exam Dumps

Verified C_DBADM_2404 dumps Q&As – C_DBADM_2404 dumps with Correct Answers

SAP C_DBADM_2404 Exam Syllabus Topics:

Topic	Details
Topic 1	Database Security: This topic explains the SAP HANA database system security concepts. Furthermore, it delves into setup audit policies.
Topic 2	Provisioning SAP HANA: This topic discusses how to accomplish sizing and provisioning tasks for different SAP HANA deployment options.
Topic 3	SAP HANA Architecture: In this topic, questions about describing SAP HANA database system architecture appear.
Topic 4	Database Administration: It focuses on how to perform daily tasks related to database administration tasks on SAP HANA.
Topic 5	User Management: It explains how to create SAP HANA user groups, users, roles to set up database access management.

NO.17 What is the primary use of the SQL Trace tool in SAP HANA?

User authentication

Performance tuning

Backup operations

Data modeling

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

Full back up, differential backup, log backup

Incremental backup, log backup

Full back up, log backup

Full back up, incremental backup, log backup

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

Replica

Data lake

Native storage extension

WORM device

NO.20 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 with the data lake on premise.

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

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

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

Data lake files

Local computer

Google Cloud Storage

HPE GreenLake

IBM public cloud

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

alter system start database <DATABASE_NAME>

cf update-service <SERVICE_INSTANCE> -c “{ “data”: {“service Stopped”: false}}”

sapcontrol -nr <INSTANCE_NUMBER>-function StartSystem

of start <APPLICATION_NAME>

NO.23 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.

hana

relational data lake

multi-environment tools

tools

NO.24 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.

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”.

User Group must be set to “Restricted”.

PUBLIC role must be set to “No”.

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

The tenant database must be stopped before the recovery starts.

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

The logon credentials of the <sid>adm user must be available.

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

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

Functions

Views

Procedures

Schemas

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

Functions

Views

Procedures

Schemas

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

Cubes

HDI containers

Agents

Cockpit roles

JSON collections

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

Automatic backup creation

Availability zone

Number of coordinators

Compatibility with SAP IQ

Compatibility with Apache Hadoop

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

LDAP identity provider

Scopes

LDAP authorization mode

User group

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

Dynamic tiering

Disk-based

In-memory

Extension node

NO.32 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 HANA database

SAP SQL Anywhere

SAP IQ

Data lake

NO.33 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.

Native storage extension

In-memory

Data lake

Hadoop distributed file system

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

Replica

Data lake

Native storage extension

WORM device

NO.35 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.

DRAM required for the static data memory area

Total disk space required for the log volume

Persistent memory (PMEM) required for backups

Network bandwidth for the storage zone

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

rename_system

unregister_system

update_host

configure_internal_network

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

SYSTEM

DBADMIN

COCKPIT MONITOR

HDLADMIN

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

Upgrade the replica first

Select the version to

install Upgrade without restart

Revert to a previous version