Updated Sep-2024 Pass C_DBADM_2404 Exam – Real Practice Test Questions [Q21-Q44]

C_DBADM_2404 SAP

admin • September 29, 2024

Updated Sep-2024 Pass C_DBADM_2404 Exam – Real Practice Test Questions [Q21-Q44]

5/5 - (3 votes)

Updated Sep-2024 Pass C_DBADM_2404 Exam – Real Practice Test Questions

Download Free SAP C_DBADM_2404 Real Exam Questions

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	Backup and Recovery: This topic discusses configuring and performing SAP HANA database system backups and restores.
Topic 3	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 4	Provisioning SAP HANA: This topic discusses how to accomplish sizing and provisioning tasks for different SAP HANA deployment options.
Topic 5	SAP HANA Architecture: In this topic, questions about describing SAP HANA database system architecture appear.
Topic 6	User Management: It explains how to create SAP HANA user groups, users, roles to set up database access management.

QUESTION 21
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 has more nodes than the target system.

The source system and target system have different SIDS.

The source system and target system have different CPU architecture.

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

QUESTION 22
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 log backup

An aborted recovery of a complete data backup

An aborted recovery of the catalog backup

You can resume the failed recovery of your productive SAP HANA tenant database in the following situations:
* An aborted recovery of a delta data backup: Resuming from a delta backup is possible because these backups capture changes since the last full or another delta backup, allowing the recovery process to continue from the last successful point.
* An aborted recovery of a log backup: Log backups contain all the transactions since the last log or data backup. If the recovery from these backups is interrupted, it can be resumed because the log contains all necessary information to bring the database to a consistent state up to the point of failure.
References=SAP HANA backup and recovery documentation explains the mechanisms and capabilities of the database’s recovery features, including scenarios where recovery processes can be resumed after interruption.
Backup and Recovery

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

Replicas

vCPUs

Storage

Memory

When scaling down an SAP HANA Cloud, SAP HANA database instance, the following resources are affected:
* vCPUs: Reducing the number of virtual CPUs will decrease the processing power available to the database instance.
* Memory: Lowering the memory allocation impacts the amount of data that can be stored in-memory, affecting performance and capacity.
References=SAP HANA Cloud service documentation provides details on the impact of scaling operations on database resources, emphasizing the change in compute and memory resources.
Provisioning SAP HANA

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

The maximum number of replicas you can configure for SAP HANA Cloud is 2. SAP HANA Cloud allows setting up a primary instance and up to two secondary (replica) instances. This is designed to enhance high availability and disaster recovery capabilities. Secondary instances can be used for failover scenarios, where if the primary instance fails, one of the secondary instances can take over to ensure continuity of service without data loss.References= This information is consistent with SAP HANA Cloud documentation and best practices for database replication and high availability setups.
Database Security

QUESTION 25
Which SAP HANA feature is responsible for managing multiple containers within the same database?

XS Advanced

SAP Landscape Transformation

Multitenant Database Containers (MDC)

Lifecycle Manager

QUESTION 26
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

QUESTION 27
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

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

Kubernetes container

SAP HANA Cloud Central

Cloud Foundry runtime

Kyma runtime

The SAP HANA Cloud, SAP HANA database runs in SAP BTP within the “SAP HANA Cloud Central.” This is the central management hub for SAP HANA Cloud instances, providing tools and interfaces for configuration, monitoring, and administration of database resources on the SAP Business Technology Platform.References= SAP BTP documentation and SAP HANA Cloud guides, which describe the integration and management of SAP HANA within the broader SAP cloud ecosystem.
SAP HANA Architecture

QUESTION 29
What feature of SAP HANA allows for the extension of storage capabilities without affecting the performance of in-memory operations?

Dynamic Tiering

Multi-tenant database containers

Persistent memory

SAP HANA Cockpit

QUESTION 30
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

Change instance backup schedule

Decrease data volume size

Create instance

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

HDLADMIN

SAPSA

DBA

DBADMIN

When adding a data lake to an SAP HANA Cloud, SAP HANA database, theHDLADMINuser is automatically created. This user is specifically designed for managing and administering the data lake environment within SAP HANA Cloud.
References=SAP HANA Cloud documentation provides information on data lake integration, including details about default users such as HDLADMIN and their roles.
Provisioning SAP HANA

QUESTION 32
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

QUESTION 33
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

QUESTION 34
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.

In a multitenant database container (MDC) system of SAP HANA, to run queries across tenant databases, it is necessary that: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.This ensures secure and controlled access across different tenant databases, where each tenant database can be isolated and independently managed.
Activating cross-tenant communication explicitly is a security measure to prevent unauthorized access across tenants.References= SAP HANA Administration Guide and SAP HANA Security Guide which detail user rights management and cross-tenant access configurations.
Database Security

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

Time travel

Single table backup

Fallback snapshots

Data snapshots

QUESTION 36
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.

Replicas

vCPUs

Storage

Memory

QUESTION 37
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 stopped.

The tenant database backups are renamed.

The tenant database trace directory is renamed.

The tenant database is unloaded from memory.

When renaming a tenant database in the SAP HANA cockpit, the following occurs:
* The tenant database is stopped: Renaming requires that the database be stopped to change its identifier and update related metadata.
* The tenant database is unloaded from memory: To apply the new name and ensure all configurations and metadata are updated, the database must be unloaded from memory.
References=This process is detailed in the SAP HANA administration guide, which outlines the steps and implications of database renaming, including the requirement to stop and unload the database.
Database Administration

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

multidb.ini

attributes.ini

global.ini

indexserver.ini

QUESTION 39
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.

To initiate a recovery of your SAP HANA Cloud, SAP HANA database instance, you use:
* In the SAP HANA cockpit, select the Start Recovery option and set the timestamp: This method provides a user-friendly interface through the SAP HANA cockpit for administrators to precisely control the recovery process, including the selection of specific recovery points based on timestamps.
References=The process for initiating database recovery through the SAP HANA cockpit is detailed in SAP HANA Cloud administration and recovery documentation, which includes step-by-step instructions for performing recoveries.
Backup and Recovery

QUESTION 40
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

Holding the object privilege “ALL PRIVILEGES” in SAP HANA provides a user with the ability to perform all available actions on specified database objects. Specifically:
* Functions: Users can create, execute, alter, and drop functions within the database, allowing for complex operations and calculations to be encapsulated within callable routines.
* Procedures: These are sets of SQL statements grouped into logical units and stored in the database.
With “ALL PRIVILEGES”, a user can create, execute, modify, and delete stored procedures.
References=This information aligns with SAP HANA security model guidelines which discuss object privileges and their impact on database objects such as functions and procedures.
User Management

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

CommonCryptoLib

Libgcrypt

OpenSSL

LibreSSL

QUESTION 42
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

QUESTION 43
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?

2 weeks

3 months

1 year

7 months

In the context of SAP HANA Cloud, when a new version of the SAP HANA database is available, if the upgrade is not performed manually, there is a specific timeframe provided before the system automatically upgrades. This period is generally set to ensure minimal disruption and to provide ample time for users to prepare or complete necessary checks:
* 3 months (B): This period is typically given to allow customers to schedule and plan the upgrade at a convenient time, ensuring compatibility with their applications and reducing the risk of unforeseen issues. This automatic upgrade policy helps maintain system integrity and security by ensuring that all instances run on supported versions of the software.
References= Information regarding upgrade policies and procedures for SAP HANA Cloud is available through official SAP HANA Cloud release notes and maintenance guidelines, which describe the upgrade paths and automation features designed to maintain system currency and stability.
SAP HANA Architecture

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

Dynamic tiering

Disk-based

In-memory

Extension node

In SAP HANA Cloud, native storage extension utilizes dynamic tiering. This approach integrates dynamic tiering by extending in-memory tables with disk-based storage, allowing data to be managed across different storage tiers. Dynamic tiering is particularly effective for managing large volumes of data where not all data needs to reside in memory, thus balancing performance with cost efficiency.References= SAP HANA Cloud documentation on storage and data management, which explains the functionality and benefits of using dynamic tiering within the database system.
SAP HANA Architecture

Loading …