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. Use the UPGANA.XML analysis file to optimize the number of R3load processes. Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence. Use the Test Cycle option to determine the optimal number of R3load processes. Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables.
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 configuration files .
In which scenario do you need SAP expert sizing? Note: There are 2 correct answers to this question. Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA Customer is new to SAP ERP applications and the SAP HANA database system Carving out SAP ERP functionality from the source system to the SAP ERP system on SAP HANA When migrating existing SAP ERP systems from AnyDB to run on SAP HANA .
What are the merge methods that are triggered by the SAP HANA system? Note: There are 2 correct answers to this question. Smart Auto Forced Critical .
What is the correct sequence of the following four steps when you restart the SAP HANA database system? Choose the correct answer. 1. Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded. 1. Aborted transactions are rolled back. 2. Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded. 1. Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back. 1. Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded. .
Which connection type is used by default for restricted users? Choose the correct answer. HTTP/S OLEDB ODBC JDBC .
You want to perform the database migration option (DMO) procedure. Which components have to be updated if they are not on the right version level? Note: There are 2 correct answers to this question. SPAM/SAINT ABAP Kernel ST-PI SAP Host q .
What cryptographic libraries are supported in SAP HANA by default? Note: There are 2 correct answers to this question. Libgcrypt Open SSL wolfCrypt Common CryptoLib .
What is a characteristic of the delta data shipping operation mode in SAP HANA system replication? Choose the correct answer. It takes place every 5 minutes. It takes place in addition to continuous log replay. It takes place with continuous read-only access to the secondary system. It takes place in addition to continuous log shipping. .
Which feature do you configure to prevent the whole SAP HANA database system from reaching physical processing limits?
Note: There are 2 correct answers to this question.
Performance trace Admission control Capture and replay Workload classes .
Which operating system process takes care of starting the SAP HANA database system services? Choose the correct answer. sapstartsrv hdbdaemon sapstart hdbrsutil .
How are savepoints triggered? Note: There are 2 correct answers to this question. By performing a database backup By a database soft shutdown By performing a delta merge By issuing a transactional commit .
Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings? Note: There are 2 correct answers to this question. /hana/shared /hana/log/<SID> /usr/sap/<SID> /usr/sap/hostctrl.
Which technology is utilized by the Performance Warehouse option in the transaction DBACOCKPIT? Choose the correct answer. SAP Analytics Cloud SAP Business Intelligence SAP Intelligent Query (SAP IQ) SAP Data Warehouse Cloud .
Which role do you need in order to assign users to groups in the SAP HANA cockpit? Choose the correct answer. Cockpit Administrator Role Cockpit Database Administrator Role Cockpit User Role Cockpit User Administrator Role .
Which SAP HANA cockpit application can you use to investigate a system offline situation? Note: There are 2 correct answers to this question. Out-of-memory event monitor CPU usage monitor Full system information dumps Troubleshoot unresponsive system .
Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question. The name server provides index server functionality for the system database. A multitenant database container system is identified by a single system ID (SID). The name server owns information about the location of tables and table partitions in databases. Database isolation increases the isolation between tenant databases on operating system level Each tenant database runs its own compile server and the pre- processor server.
Which properties can you adjust in SAP HANA admission control? Note: There are 3 correct answers to this question. Maximum number of parallel IO requests Memory threshold for queuing new requests Maximum queue size for requests Memory limits for new SQL statement requests CPU threshold for rejecting new requests .
You are planning an SAP S/4HANA scale-out system. What are the minimal size requirements for CPU and memory? Choose the correct answer. RAM: >= 6TB, CPU: >=12 RAM: >= 8TB, CPU: >=12 RAM: >= 6TB, CPU: >= 8 RAM: >= 4TB, CPU: >= 8 .
How does SAP HANA encrypt the data persistence layer? Choose the correct answer. By table level
By page level
By column level By row level .
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. The SAP system can be AS Java-based if the release is 7.50 or higher. A database migration from Oracle to SAP MaxDB can be performed. The primary application server (PAS) can be moved to a target system landscape. A database migration from SAP HANA to SAP ASE can be performed.
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. GPFS OCFS2 Btrfs XFS .
For an SAP HANA tailored data center integration (TDI) approach, what is the additional disk space factor required during delta merge operations? Choose the correct answer. 3 1.6 2 1.2 .
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. When a commit occurs When the log buffer is full When the log segment is full When the time threshold is exceeded .
Which types of backups can you use to copy an SAP HANA tenant database? Note: There are 2 correct answers to this question. Fallback snapshot Delta database backup Full database backup Data snapshot .
How are hosts assigned to the shared storage in the SAP HANA scale-out system? Note: There are 2 correct answers to this question. The master node is assigned to its own data volume. The standby node is assigned to the worker data volume. The master node is assigned to all log volumes. The worker nodes are assigned to their own log volumes.
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed? Choose the correct answer. SQL End-to-end Kernel profiler User-specific .
Which prerequisites must be fulfilled before adding hosts to an SAP HANA scale-out system? Note: There are 2 correct answers to this question. The SAP HANA system installation is on a shared file system. The SAP HANA database server is shut down. The additional host is placed in a different data center. The host has access to the installation directories. .
In a multitenant database container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases? Choose the correct answer. DATABASE ADMIN BACKUP ADMIN BACKUP OPERATOR TENANT ADMIN.
Which table holds the data used for the dynamic management of partitions and locations? Choose the correct answer. TABLE_PLACEMENT UPDATE_LANDSCAPE_CONFIGURATION TABLE_GROUP EFFECTIVE_TABLE_PLACEMENT .
Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app? Note: There are 2 correct answers to this question. Index server Preprocessor Compile server Daemon .
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? Choose the correct answer. 0.5 TB 1.5 TB 2.0 TB 1.0 TB .
You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system? Choose the correct answer. Syncing Error Initializing Unknown .
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. User SYSTEM of the target system database S-user for the SAP Support Portal User DBACOCKPIT of the target tenant database User SAP* of client 000 of the SAP system User DDIC of client 000 of the SAP system.
You are running a database migration option (DMO) procedure using in-place migration. Where are the reading and writing R3load processes located during the actual migration? Choose the correct answer.
All of the reading and writing processes run on the target database host. All of the reading and writing processes run on the primary application server (PAS) host. The reading processes run on the primary application server (PAS) host; the writing processes run on the target database host. The reading processes run on the source database host; the writing processes run on the target database host.
How are user group administrators and user groups related? Note: There are 2 correct answers to this question. Only one user group administrator per user group Multiple user group administrators per user group Multiple user groups per user group administrator Only one user group per user group administrator .
Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit? Choose the correct answer. WORKLOAD ADMIN INIFILE ADMIN RESOURCE ADMIN DATABASE ADMIN .
During the delta merge process, to which memory areas is data inserted? Note: There are 2 correct answers to this question. Main 2 Delta 1 Main 1 Delta 2 .
Who owns an SAP HANA Deployment Infrastructure (HDI) role? Choose the correct answer. The container-specific technical user The SYSTEM user of the tenant database The user who created the role The _SYS_REPO technical user .
Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? Note: There are 2 correct answers to this question. SYNC SYNCMEM FULL SYNC ASYNC .
Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? Note: There are 2 correct answers to this question. Create credentials for authenticated access to the source system. Create a tenant on the target system identical to the source system. Configure a secure connection from target system to source system. Back up the source tenant database. .
Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header?
Choose the correct answer. Hdbbackupcheck hdbbackint hdbbackupdiag hdbrecovercheck .
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. Lock the <sid>adm OS user. Add dedicated tenant OS users to the <sid>shm group. Create dedicated tenant OS users for each tenant. Add dedicated tenant OS users to the sapsys group. Remove the <sid>adm OS user from the sapsys group. .
How can you ensure that a consistent database status is saved using data snapshots? Choose the correct answer. Create an internal database snapshot. Trigger a savepoint. Execute the hdbbackupdiag tool. Create a fallback snapshot. .
Which system usage types are automatically assigned to tiles in the SAP HANA cockpit? Note: There are 3 correct answers to this question. Production Development Test Custom Quality assurance .
Which technology is used to install the SAP Landscape Management tool? Choose the correct answer. SAP Fiori launchpad SAP NetWeaver Application Server for ABAP SAP NetWeaver Application Server for Java SAP HANA XS advanced runtime .
Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question. Update the SAP HANA database system. Stop and start the SAP HANA database system. Configure the system landscape directory registration. Manage the full system information dumps. .
What can you check with the SAP HANA hardware and cloud measurement tools (HCMT)? Choose the correct answer. Linux kernel information NUMA memory bandwidth test Cloud connector status CPU states .
Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question. Rename the SAP HANA database system. Update the SAP HANA database system and its components. Uninstall the SAP HANA database system and its components. Extract the SAP HANA database system components. .
What is the purpose of the SAP HANA secure user store (hdbuserstore)? Note: There are 2 correct answers to this question. To configure an SAP HANA auto-restart for fault recovery To configure failover support in a 3-tier scenario To store connection information on the SAP HANA XS advanced engine To store connection information on the SAP HANA database client.
Which actions are performed during the database migration option (DMO) procedure when you select the IDo not compare table contentsI option? Note: There are 2 correct answers to this question. The content comparison is performed for repository tables. The clustered tables are declustered. A checksum is generated every 10000 rows. A row count is executed for the migrated tables.
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. The user in the source system must have sufficient privileges in the target database. The user in the source system must be associated with a user in the target database. The cross-tenant database communication must be explicitly activated. The bidirectional communication channel must be whitelisted. .
Which tools are integrated into the SAP HANA cockpit? Note: There are 3 correct answers to this question. HANASitter SQL Analyzer SQL Console Database Explorer HDBAdmin .
You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as an in-place migration. Which steps take place during downtime? Note: There are 2 correct answers to this question. Migration of application tables in phase EU_CLONE_MIG_DT_RUN XPRAS execution in phase XPRAS_AIMMRG Creation of application tables in the target database in phase EU_CLONE_MIG_DT_CREATE Activation of dictionary objects in phase ACT_UPG .
Which actions take place during a database migration option (DMO) procedure when performing an in-place migration? Note: There are 2 correct answers to this question. De-pooling of tables is done during the procedure. One table is migrated per R3load pair. SAPup decides which tables to split. TABART is considered for the creation of R3load control files. .
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. LDAP identity provider LDAP authorization mode User group Scopes .
Which schema provides performance data and alert details to review in SAP HANA mini-checks? Choose the correct answer. COCKPIT_MONITOR _SYS_SQL_ANALYZER _SYS_STATISTICS SAP_XS_USAGE .
You want to implement a 28-day backup cycle. Which scenario uses the least storage? Choose the correct answer. Full backup, incremental backup, log backup Full backup, log backup Incremental backup, log backup Full backup, differential backup, log backup .
Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question. Views Schemas Functions Procedures .
What additional action do you need to perform after you create a new tenant in an SAP HANA system replication configuration? Choose the correct answer. Copy the tenant database. Restart the secondary system. Back up the tenant database. Start the tenant database.
Which parameters are mandatory when using the HDBLCM tool to install the SAP HANA database system in batch mode? Note: There are 2 correct answers to this question. Password of user sapadm Installation path Data and log path SAP HANA System ID (SID) .
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. SYSTEM SAP<SID> sapadm <sid>crypt .
Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit? Note: There are 3 correct answers to this question. <sid>adm Cockpit User Database User Root sap<sid> .
Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system? Choose the correct answer. Total disk space required for the log volume DRAM required for the static data memory area Network bandwidth for the storage zone Persistent memory (PMEM) required for backups .
Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure? Note: There are 2 correct answers to this question. The source database is up and running. The SUM folder needs to exist. A cleanup has already been triggered. The DMO procedure hasn't reached downtime yet.
Which rules should you consider when creating a table distribution plan for SAP Business Suite powered by SAP HANA to get the best possible results? Note: There are 2 correct answers to this question. Keep all partitions on different hosts. Keep the number of partitions per table high. Keep the number of partitioned tables low. Keep the number of key columns low. .
Which prerequisites of the primary system and the secondary system are mandatory before you can activate SAP HANA system replication with secondary time travel? Note: There are 2 correct answers to this question. The CPU architecture must be identical. An explicit read-only connection between both systems must be available. Both systems are located in the same data center. Both must have the same SAP HANA version.
Which features do you need to activate before you can analyze the memory usage of running SQL statements? Note: There are 2 correct answers to this question. In-memory tracing Tracking Statement memory limit Memory tracking .
Which system privileges are required for administrating tenant databases when connected to the system database? Choose the correct answer. DATABASE ADMIN BACKUP ADMIN DATA ADMIN MONITOR ADMIN .
Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start? Choose the correct answer. sapcontrol HDBAdmin RecoverStateChecker.py Hdbcons .
The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions, and threads? Note: There are 2 correct answers to this question. emergencyInfo.py Manage full system information dumps PerfTrace.py Troubleshoot unresponsive systems .
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. User creation Password policy configuration User group assignment Role assignment .
Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note: There are 2 correct answers to this question. Fallback snapshot Delta backup Data snapshot Full backup .
How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question. Using the resident hdblcm tool Using the hdbuserstore tool Using the Manage Restricted Features app Using the Manage Database Configuration app .
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. SELECT on the _SYS_STATISTICS schema CATALOG READ SELECT on the _SYS_TELEMETRY schema DATABASE ADMIN .
Which prerequisites must be fulfilled to rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question. The on-disk tenant directory should be a mount point. The tenant database must be unloaded from memory. The tenant database is not part of a move operation. The tenant database is stopped.
Which feature do you use to dynamically manage SAP HANA database workloads per client session? Choose the correct answer. Admission control Parallel execution of SQL statements Non-Uniform Memory Access (NUMA) Workload classes .
What is the recommended size for the log volume file system for a 512 GB SAP HANA database system? Choose the correct answer. 427 GB 614 GB 512 GB 256 GB .
What action(s) can you perform in the SAP HANA cockpit to back up the complete database system? Choose the correct answer. Back up the system database and all tenant databases individually. Back up the system database and all tenant databases in one step. Back up the system using a fallback snapshot for every database. Back up the system using a database snapshot and a data snapshot. .
Which system privilege do you need to redistribute tables across the hosts in a scale-out system? Choose the correct answer. WORKLOAD ADMIN DATA ADMIN OPTIMIZER ADMIN None RESOURCE ADMIN .
|
