SAP C_DBADM_2404 Test Engine Dumps Training With 87 Questions [Q33-Q54]

admin C_DBADM_2404 SAP October 8, 2024

Rate this post

SAP C_DBADM_2404 Test Engine Dumps Training With 87 Questions

C_DBADM_2404 Questions Pass on Your First Attempt Dumps for SAP Certified Associate Certified

SAP C_DBADM_2404 Exam Syllabus Topics:

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

NO.33 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.34 Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit?

INIFILE ADMIN

RESOURCE ADMIN

SERVICE ADMIN

DATABASE ADMIN

NO.35 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.36 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.37 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.38 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.

Password policies

Users

Permissions

Roles

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

SAP HANA Cloud Central

SAP BTP cockpit

SAP HANA cockpit

SAP HANA database explorer

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

XFS

Btrfs

GPFS

EXT4

NO.41 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 cross-tenant database communication must be explicitly activated.

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

The bidirectional communication channel must be allowed.

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

Using the Auditing card in the SAP HANA cockpit

Using the SQL Console in the SAP HANA database explorer

Using the kernel profiler trace in the SAP HANA database explorer

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

Kubernetes container

SAP HANA Cloud Central

Cloud Foundry runtime

Kyma runtime

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

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

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

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

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

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

Database table

Kernel trace

Linux syslog

CSV text file

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

Update the SAP HANA database system and its components.

Rename the SAP HANA database system.

Uninstall the SAP HANA database system and its components.

Extract the SAP HANA database system components.

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

DATABASE ADMIN

DATA ADMIN

MONITOR ADMIN

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

User creation

Password policy configuration

Role assignment

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

Workload classes

Workload analysis

Admission control

Load unit configuration

NO.51 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.52 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

DATABASE ADMIN

DATA ADMIN

MONITOR ADMIN

NO.53 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.54 What can you store in the statement library? Note: There are 2 correct answers to this question.

The executed statements trace