Exam4Training

SAP C_DBADM_2404 SAP Certified Associate – Database Administrator – SAP HANA Online Training

Question #1

Which SAP HANA Cloud tools would you use to diagnose and analyze errors in database trace files? Note: There are 2 correct answers to this question.

  • A . SAP HANA database explorer
  • B . SAP HANA Cloud Central
  • C . SQL trace analyzer
  • D . Full system information dump

Reveal Solution Hide Solution

Correct Answer: A D
Question #2

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

  • A . Alert Monitor
  • B . Full System Information Dumps
  • C . Troubleshoot Unresponsive System
  • D . Performance Monitor

Reveal Solution Hide Solution

Correct Answer: C
Question #3

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

  • A . End-to-end
  • B . Kernel profiler
  • C . SQL
  • D . Performance trace

Reveal Solution Hide Solution

Correct Answer: B
Question #4

You want to compare and analyze session-specific data.

In what format can you save data sets from the SAP HANA cockpit sessions app? Note: There are 3 correct answers to this question.

  • A . HTML file
  • B . XML file
  • C . TXT file
  • D . JSON file
  • E . CSV file

Reveal Solution Hide Solution

Correct Answer: A C E
Question #5

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

  • A . The executed statements trace
  • B . Your personal stored procedures
  • C . Your personal SQL scripts
  • D . The SAP SQL statement collection

Reveal Solution Hide Solution

Correct Answer: C D
Question #6

From which system views can you export content when using the Performance Monitor app? Note: There are 3 correct answers to this question.

  • A . SYS.M_WORKLOAD
  • B . SYS.M_SERVICE_STATISTICS
  • C . SYS.M_LOAD_HISTORY_HOST
  • D . SYS.M_SERVICES
  • E . SYS.M DATABASE

Reveal Solution Hide Solution

Correct Answer: C D E
Question #7

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

  • 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

Reveal Solution Hide Solution

Correct Answer: A D
Question #8

Which properties can you change in the Alert Definitions app? Note: There are 3 correct answers to this question.

  • A . The interval settings
  • B . The proposed solution
  • C . The category
  • D . The schedule
  • E . The thresholds

Reveal Solution Hide Solution

Correct Answer: A D E
Question #9

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.

  • A . Slack
  • B . Microsoft Teams
  • C . WhatsApp
  • D . Signal

Reveal Solution Hide Solution

Correct Answer: A B
Question #10

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

  • A . SAP HANA Cloud Central
  • B . SAP BTP cockpit
  • C . SAP HANA cockpit
  • D . SAP HANA database explorer

Reveal Solution Hide Solution

Correct Answer: C D

Question #11

Which services are shared in the Manage Services app in the SAP HANA Cloud database? Note: There are 2 correct answers to this question.

  • A . Compile server
  • B . Name server
  • C . DP server
  • D . DI server

Reveal Solution Hide Solution

Correct Answer: A B
Question #12

What can you check with the SAP HANA hardware and cloud measurement tool (HCMT)? Note: There are 2 correct answers to this question.

  • A . Linux kernel information
  • B . Cloud connector status
  • C . CPU states
  • D . NUMA memory bandwidth test

Reveal Solution Hide Solution

Correct Answer: C D
Question #13

Which tools are available in SAP HANA Cloud Central? Note: There are 2 correct answers to this question.

  • A . Service Plan Assignment editor
  • B . Start Recovery wizard
  • C . Manage Configuration editor
  • D . Cloud Foundry CLI

Reveal Solution Hide Solution

Correct Answer: B C
Question #14

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

  • A . Workload classes
  • B . Workload analysis
  • C . Admission control
  • D . Load unit configuration

Reveal Solution Hide Solution

Correct Answer: A
Question #15

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

  • A . 1
  • B . 3
  • C . 2
  • D . 4

Reveal Solution Hide Solution

Correct Answer: C
Question #16

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.

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

Reveal Solution Hide Solution

Correct Answer: A B
Question #17

How can you view the audit trail in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

  • A . Using the expensive statements trace in the SAP HANA cockpit
  • B . Using the Auditing card in the SAP HANA cockpit
  • C . Using the SQL Console in the SAP HANA database explorer
  • D . Using the kernel profiler trace in the SAP HANA database explorer

Reveal Solution Hide Solution

Correct Answer: B C
Question #18

Which options for Audited Action Status are available in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

  • A . Critical
  • B . Enabled
  • C . All
  • D . Unsuccessful

Reveal Solution Hide Solution

Correct Answer: C D
Question #19

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

  • A . Database table
  • B . Kernel trace
  • C . Linux syslog
  • D . CSV text file

Reveal Solution Hide Solution

Correct Answer: A
Question #20

What is the default single sign-on method when using hdbsql?

  • A . Token based
  • B . SAML based
  • C . Kerberos based
  • D . Certificate based

Reveal Solution Hide Solution

Correct Answer: B

Question #21

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

  • A . Docker
  • B . Kubernetes
  • C . Runtime
  • D . Design time

Reveal Solution Hide Solution

Correct Answer: C D
Question #22

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.

  • A . User group assignment
  • B . User creation
  • C . Password policy configuration
  • D . Role assignment

Reveal Solution Hide Solution

Correct Answer: B D
Question #23

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

  • 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

Reveal Solution Hide Solution

Correct Answer: D
Question #24

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

  • A . CommonCryptoLib
  • B . Libgcrypt
  • C . OpenSSL
  • D . LibreSSL

Reveal Solution Hide Solution

Correct Answer: A C
Question #25

How are savepoints triggered?

Note: There are 2 correct answers to this question.

  • A . By performing a delta merge
  • B . By issuing a transactional commit
  • C . By a database soft shutdown
  • D . By performing a database backup

Reveal Solution Hide Solution

Correct Answer: C D
Question #26

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.

  • 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

Reveal Solution Hide Solution

Correct Answer: A B
Question #27

In which scenario do you need SAP expert sizing? Note: There are 2 correct answers to this question.

  • A . Migrating existing SAP ERP systems from AnyDB to run on SAP HANA
  • B . Customer is new to SAP ERP applications and the SAP HANA database system
  • C . Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA
  • D . Carving out SAP ERP functionality from the source system to the SAP ERP system on SAP HANA

Reveal Solution Hide Solution

Correct Answer: C D
Question #28

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

  • A . Dynamic tiering
  • B . Disk-based
  • C . In-memory
  • D . Extension node

Reveal Solution Hide Solution

Correct Answer: B
Question #29

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

  • A . Upgrade the replica first
  • B . Select the version to
  • C . install Upgrade without restart
  • D . Revert to a previous version

Reveal Solution Hide Solution

Correct Answer: B C
Question #30

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

  • A . Kubernetes container
  • B . SAP HANA Cloud Central
  • C . Cloud Foundry runtime
  • D . Kyma runtime

Reveal Solution Hide Solution

Correct Answer: A
Exit mobile version