SAP Certified Technology Associate Database Administrator Free Sample Questions

To achieve an RPO of zero, the replication mode must be synchronous ('sync' or 'syncmem'). The 'sync' mode ensures that the primary system commits a transaction only after receiving confirmation that the logs have been persisted on the secondary site. To allow read access on the secondary system, the operation mode must be 'logreplay_readaccess'. This combination meets both requirements. 'async' mode does not guarantee RPO=0. 'delta_datashipping' is an older mode and does not allow read access. 'logreplay' alone does not enable read access for reporting.

SAP HANA supports enabling both log and data volume encryption online. Log volume encryption can be enabled and takes effect immediately for new log segments. Data volume encryption can also be enabled while the system is online. Once enabled, all pages written to the data volume during subsequent savepoints will be encrypted. Over time, the entire data volume becomes encrypted without requiring a full database outage or a backup/restore cycle, thus minimizing disruption.

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.

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.

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.

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.

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.

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.

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.

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.