Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question.
- A . A multitenant database container system is identified by a single system ID (SID).
- B . Database isolation increases the isolation between tenant databases on operating system level
- C . Each tenant database runs its own compile server and the preprocessor server.
- D . The name server owns information about the location of tables and table partitions in databases.
- E . The name server provides index server functionality for the system database.
Your customer has purchased a 3 TB SAP HANA license.
TO which value do you set the GLOBAL ALLOCATION LIMIT parameter when you have four 2 TB nodes in an SAP HANA scale-out system consisting of three worker and one standby nodes?
- A . 1.5 TB
- B . 0.5 TB
- C . 2.0 TB
- D . 1.0 TB
Which migration features are supported when using the database migration option (DMO) of Software Update Manager (SUM)? Note: There are 2 correct answers to this question.
- A . The primary application server (PAS) can be moved to a target system landscape.
- B . A database migration from Oracle to SAP MaxDB can be performed.
- C . A database migration from SAP HANA to SAP ASE can be performed
- D . The SAP system can be AS Java-based if the release is 7.50 or higher
Which user credentials are required when performing a database migration option (DMO) procedure to SAP HANA 2.0? Note: There are 3 correct answers to this question.
- A . S-user for the SAP Support Portal
- B . User DDIC of client 000 of the SAP system
- C . User SYSTEM of the target system database
- D . User SAP* of client 000 of the SAP system
- E . User DBACOCKPIT of the target tenant database
You are running an SAP HANA database in log mode "normal"
Under what circumstances does the database automatically execute a regular log backup? Note: There are 2 correct answers to this question.
- A . When the log segment is full
- B . When a commit occurs
- C . When the time threshold is exceeded
- D . When the log buffer is full
What is the purpose of the SAP HANA secure user store (hdbuserstore)? Note: There are 2 correct answers to this question.
- A . TO configure failover support in a 3-tier scenario
- B . TO store connection information on the SAP HANA XS advanced engine
- C . TO configure an SAP HANA auto-restart for fault recovery
- D . TO store connection information on the SAP HANA database client
Which technology is utilized by the Performance Warehouse option in the transaction DBACOCKPIT?
- A . SAP Business Intelligence
- B . SAP Data Warehouse Cloud
- C . SAP Analytics Cloud
- D . SAP Intelligent Query (SAP 10)
In which scenario do need SAP expert sizing? Note: There are 2 correct answers to this question.
- A . Customer is new to SAP ERP applications and the SAP HANA database system
- B . Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA
- C . Carving out SAP ERP functionality from the source system to the SAP ERP system on SAP HANA
- D . When migrating existing SAP ERP systems from AnyDB to run on SAP HANA
When performing a standard SAP HANA database system installation, which users Will be created or validated during that installation? Note: There are 2 correct answers to this question.
- A . SYSTEM
- B . <sid>crypt
- C . SAP<SID>
- D . sapadm
You are registering an SAP HANA database resource using SAP HANA cockpit manager.
Which privileges are automatically assigned when you initially create the COCKPIT MONITOR technical user? Note: There are 2 correct answers to this question.
- A . DATABASE ADMIN
- B . SELECT on the SYS TELEMETRY schema
- C . CATALOG RAED
- D . SELECT on the SYS STATISTICS schema
How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question.
- A . Using the resident hdblcm tool
- B . Using the Manage Restricted Features app
- C . Using the Manage Database Configuration app
- D . Using the hdbuserstore tool
Which table holds the data used for the dynamic management of partitions and locations?
- A . TABLE GROUP
- B . UPDATE LANDSCAPE CONFIGURATION
- C . TABLE PLACEMENT
- D . EFFECTIVE TABLE PLACEMENT
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.
- A . An aborted recovery of a delta data backup
- B . An aborted recovery of a log backup
- C . An aborted recovery of a complete data backup
- D . An aborted recovery of the configuration files
What action(s) can you perform in the SAP HANA cockpit to back up the complete database system?
- A . Back up the system using a fallback snapshot for every database
- B . Back up the system using a database snapshot and a data snapshot.
- C . Back up the system database and all tenant databases in one step
- D . Back up the system database and all tenant databases individually
Which database objects can manipulate if you have the Object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question.
- A . Views
- B . Schemas
- C . Functions
- D . Procedures
What can you check with the SAP HANA hardware and cloud measurement tools (HCMT)? Note: There are 2 correct answers to this question.
- A . Cloud connector status
- B . Linux kernel information
- C . NUMA memory bandwidth test
- D . CPU states
Which activities do you have to carry out to configure your multitenant database container (MDC) system to a higher database isolation level between tenant databases on the operating system (OS)? Note: There are 3 correct answers to this question.
- A . Add dedicated tenant OS users to the <sid>shm group.
- B . Lock the <sid>adm OS user.
- C . Remove the <sid>adm OS user from the sapsys group.
- D . Add dedicated tenant OS users to the sapsys group.
- E . Create dedicated tenant OS users for each tenant
What additional action do you need to perform after you create a new tenant in an SAP HANA system replication configuration?
- A . Copy the tenant database
- B . Restart the secondary system.
- C . Back up the tenant database
- D . Start the tenant database
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 . Network bandwidth for the storage zone
- B . Total disk space required for the log volume
- C . Persistent memory (PMEM) required for backups
- D . DRAM required for the static data memory area
Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note: There are 2 correct answers to this question.
- A . Delta backup
- B . Full backup
- C . Fallback snapshot
- D . Data snapshot
Which system privileges are required for administrating tenant databases when connected to the system database? Note: There are 2 correct answers to this question.
- A . data admin
- B . database admin
- C . monitor admin
- D . backup admin
How can you use the results from a comparable test run to optimize the database migration option (DMO) procedure downtime for a production system? Note: There are 2 correct answers to this question.
- A . Use the MIGRATE DT DUR.XML file to optimize table splitting and migration sequence
- B . Use the Test Cycle option to determine the optimal number of R310ad processes.
- C . Use the UPGANA.XML analysis file to optimize the number of R310ad processes
- D . Use the MIGRATE SOT DUR.XML file to manually optimize table splitting of large tables.
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 creation
- B . User group assignment
- C . Password policy configuration
- D . Role assignment
In a multitenant database container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases?
- A . BACKUP OPERATOR
- B . BACKUP ADMIN
- C . TENANT ADMIN
- D . DATABASE ADMIN
Who owns an SAP HANA Deployment Infrastructure (HDI) role?
- A . The container-specific technical user
- B . The SYSTEM user of the tenant database
- C . The SYS REPO technical user
- D . The user who created the role
Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure? Note: There are 2 correct answers to this question.
- A . cleanup has already been triggered.
- B . The SUM folder needs to exist
- C . The DMO pro e hasn’t reached downtime yet
- D . The source database is up and running
How are savepoints triggered?
Note: There are 2 correct answers to this question.
- A . By issuing a transactional commit
- B . By performing a delta merge
- C . By a database soft shutdown
- D . By performing a database backup
Which actions are performed during the database migration option (DMO) procedure when you
select the ‘Do not compare table contents’ option?
Note: There are 2 correct answers to this question
- A . A check sum is generated every 10000 rows
- B . The content comparison is performed for repository tables.
- C . A row count is executed for the migrated tables
- D . The clustered tables are declustered.
Which types of backups can you use to copy an SAP HANA tenant database? Note: There are 2 correct answers to this question.
- A . Full database backup
- B . Data snapshot
- C . Delta database backup
- D . Fallback snapshot
What can you assign to a user with the User Management app in SAP HANA cockpit? Note: There are 2 correct answers to this question.
- A . LDAP authorization mode
- B . Scopes
- C . User group
- D . LDAP identity provider