UPDATED [Jul 19, 2024] Pass SAP Certified Associate – Database Administrator – SAP HANA Exam with Latest Questions [Q49-Q63]

19Jul 2024 by admin No Comments

4.5/5 - (10 votes)

UPDATED [Jul 19, 2024] Pass SAP Certified Associate – Database Administrator – SAP HANA Exam with Latest Questions

C_DBADM_2404 Exam Practice Questions prepared by SAP Professionals

QUESTION 49
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_WORKLOAD

SYS.M_SERVICE_STATISTICS

SYS.M_LOAD_HISTORY_HOST

SYS.M_SERVICES

SYS.M DATABASE

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

SQLScript

SQL Console

HDBSQL

SQL Editor

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

SAP HANA HDBSQL

SAP BTP cockpit

SAP HANA Cloud Central

SAP HANA cockpit

QUESTION 52
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 53
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”.

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

Data snapshot

Incremental backup

Complete backup

Log backup

Differential backup

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

Cockpit Administrator role

Cockpit Database Administrator role

Cockpit User Administrator rolle

Cockpit User role

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

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

Name server

DP server

DI server

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

Kubernetes container

SAP HANA Cloud Central

Cloud Foundry runtime

Kyma runtime

QUESTION 59
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 60
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 collect all the executed SQL statements and generate a searchable library list

To share custom SQL scripts with the whole administration team

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

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

QUESTION 62
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 63
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.

C_DBADM_2404 Exam Practice Materials Collection: https://www.practicematerial.com/C_DBADM_2404-exam-materials.html

Leave a Reply Cancel reply