Free C-DBADM-2404 sample questions

Correct answer: recoverSys.py

The `recoverSys.py` script is the specific tool provided by SAP for recovering the SYSTEMDB of a multi-tenant system from the command line. It is crucial to remember that this script CANNOT be used to recover tenant databases; tenant recovery must be initiated via SQL commands or graphical tools like SAP HANA Cockpit.

Correct answer: SAP HANA Database Explorer

The SAP HANA Database Explorer is the primary tool for database developers and administrators to interact directly with the database. Its key functions include running SQL queries, browsing the database catalog (schemas, tables, views), and analyzing query plans and performance. While SAP HANA Cockpit is for high-level monitoring and administration and Cloud Central is for provisioning and landscape management, the Database Explorer provides the deep-dive SQL-level access needed for this task.

Correct answers: SAP HANA Service for SAP BTP, Neo environment; SAP HANA Service for SAP BTP, Cloud Foundry environment; SAP HANA on-premise database

The self-service migration tools for SAP HANA Cloud are designed to support migrations from various SAP-managed HANA environments. According to SAP documentation (HA2HC course), this includes SAP HANA on-premise systems, the SAP HANA Service in the Neo environment, and the SAP HANA Service in the Cloud Foundry environment. SAP HANA, express edition and third-party managed services like RDS are not direct sources for these specific self-service tools.

Correct answer: False

This statement is false. Since SAP HANA 2.0, Multi-tenant Database Containers (MDC) is the default and only operational mode. A standard installation will always create a SYSTEMDB and a default tenant database. The previous single-container mode is no longer available.

Correct answer: Object Privilege

Object privileges are used to grant access to specific database objects like schemas, tables, views, or procedures. To grant read-only access (SELECT) to all tables within the `SALES_DATA` schema, the administrator should grant the `SELECT` object privilege on the `SALES_DATA` schema to the `REPORT_USER_ROLE`. This is the most direct and appropriate method. System privileges are for administrative actions, Analytic privileges are for controlling access to data within modeling views, and Package privileges are for repository packages.

Correct answer: Every 300 seconds (5 minutes)

The default interval for automatic savepoints in SAP HANA is 300 seconds, which is equivalent to 5 minutes. This is a critical parameter for database consistency and recovery performance. The 900 seconds (15 minutes) value is the default for the log backup interval, not the savepoint interval.

Correct answer: Higher compression rates and faster analytical query (OLAP) performance.

Column-store databases store data in columns rather than rows. This layout is highly advantageous for analytical queries (OLAP) because only the required columns for a query need to be read from memory/disk. Furthermore, since all data in a single column is of the same type, it allows for extremely high compression ratios. Row-store is generally faster for OLTP workloads that affect single, entire rows.

Correct answer: hdblcm

The SAP HANA Database Lifecycle Manager (`hdblcm`) is the standard command-line tool for all lifecycle management tasks. This includes initial installation, applying support packages and patches (updates), adding or removing components, and reconfiguring the system. `hdbsql` is for database queries, and `hdbnsutil` is a lower-level tool for name server administration.

Correct answers: Threads; CPU Usage

In SAP HANA Cockpit's Performance Monitor, the 'CPU Usage' view provides a direct visualization of CPU consumption over time, broken down by host and service (e.g., indexserver, nameserver). This is the primary starting point. The 'Threads' view is the next logical step, as it allows the administrator to see the details of active threads, filter by high CPU time, and identify the specific operations or SQL statements responsible for the high load.

Correct answer: AUDITOR

The `AUDITOR` standard role is specifically designed for security administrators and auditors. It grants read-only access to all system views related to security, such as audit policies, users, roles, and privileges, without granting access to application data or the ability to modify system settings. The MONITORING role is for performance monitoring, and PUBLIC is a default role with minimal privileges granted to all users.