The recovery of your productive SAP HANA tenant database fails. In which cases can you resume the incomplete recovery?
There are 2 correct answers to this question.
Aborted recovery of the configuration files Aborted recovery of a complete data backup Aborted recovery of a log backup Aborted recovery of a delta data backup.
Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit?
There are 3 correct answers to this question.
Production Development Custom Test Sandbox.
Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit?
There are 2 correct answers to this question.
Full backup Data snapshot Fall back snapshot Delta backup.
Which characteristics describe an SAP HANA multi-tenant database container (MDC) system?
There are 3 correct answers to this question.
Each tenant databse runs its own compile server and the preprocessor server. The name server provides index server funcionality 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.
Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA replication with secondary time travel?
There are 2 correct answers to this question.
Both must have the same SAP HANA version. Both systems are located in the same data center. An explicit read-only connect on between both systems must be available. The CPU architecture must be identical.
Which user credentials are required when performing a database migration option (DMO) procedure to SAP HANA 2.0?
There are 3 correct answers to this question.
S-user for the SAP Support Portal User SAP of client 000 of the SAP system User DDIC of client 000 of the SAP system User SYSTEM of the target system database User DBACOCKPIT of the target tenant database .
Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Manage the full system information dumps. Update the SAP HANA database system. Configure the system landscape directory registration. Stop and start the SAP HANA database system.
Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL?
There are 2 correct answers to this question.
HANASitter Sapcontrol hdbcons HDBAdmin.
In which situations can you resume the failed recovery of your productive SAP HANA tenant database?
There are 2 correct answers to this question.
An aborted recovery of the configuration files An aborted recovery of a log backup An aborted recovery of a complete data backup An aborted recovery of delta data backup.
Which technology is used to install the SAP Landscape Management tool?
Please choose the correct answer.
SAP HANA XS advanced runtime SAP NetWeaver Application Server for Java SAP NetWeaver Application Server for ABAP SAP Fiori launchpad.
How are savepoints triggered?
There are 2 correct answers to this question.
By performing a database backup. By issuing a transactional commit. By performing a delta merge. By a database soft shutdown.
Which file systems are supported for the data and log volumes of the SAP HANA 2.0 database system?
There are 2 correct answers to this question.
GPFS OCFS2 Btrfs XFS.
In which scenario do you need SAP expert sizing?
There are 2 correct answers to this question.
Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA When migrating existing SAP ERP systems from Any DB to run 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.
You are running an SAP HANA database in log mode "normal". Under what circumstances does the database automatically execute a regular log backup?
There are 2 correct answers to this question.
When the time threshold is exceeded When a commit occurs When the log buffer is full When the log segment is full.
You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system?
Please choose the correct answer.
Error Unknown Syncing Initializing.
You are planning an SAP S/4HANA scale-out system. What are the minimal size requirements for CPU and memory?
Please choose the correct answer.
RAM: >= 6TB, CPU: >= 8 RAM: >= 4TB, CPU: >= 8 RAM: >= 6TB, CPU: >= 12 RAM: >= 8TB, CPU: >= 12.
You want to implement a 28-day backup cycle. Which scenario uses the least storage?
Please choose the correct answer.
Full backup, log backup Incremental backup, log backup Full backup, differential backup, log backup Full backup, incremental backup, log backup.
In which cases can you load and unload individual tables and table columns manually in an SAP HANA tenant database?
There are 2 correct answers to this question.
To actively free up memory To measure total table memory To optimize the standby node memory To extend the scale-out memory.
Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure?
There are 2 correct answers to this question.
Extract the SAP HANA database software installation archive. Update the SAP Host Agent to the latest version. Check if the latest SPAM/SAINT update is applied. Move the latest R3trans update archive into the download folder.
Where is the name server running in a multitenant database container system?
Please choose the correct answer.
Standby mode SYSTEMDB Master node Each tenant.
Which parameters do you need to change before you can analyse the memory usage of running SQL statements?
There are 2 correct answers to this question.
use_in_memory_tracing memory_tracking statement_memory_limit enable_tracking.
When can you load and unload individual tables and table columns manually in an SAP HANA tenant database?
There are 2 correct answers to this question.
When you need to measure total memory. When you need to actively free up memory. When you need to optimize the standby node memory. When you need to extend the scale-out memory.
How are user group administrators and user groups related?
There are 2 correct answers to this question.
Multiple user group administrators per user group Only one user group per user group administrator Multiple user groups per user group administrator Only one user group administrator per user group.
How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system?
There are 2 correct answers to this question.
Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables. Use the UPGANA.XML analysis file to optimize the number of R3load processes. Use the Test Cycle option to determine the optimal number of R3load processes. Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence.
What is the first node limit for planning an SAP S/4HANA scale-out system?
There are 2 correct answers to this question.
>= 8CPU >= 8TB >= 12CPU >= 6TB.
What is the characteristic of the Delta Data Shipping operation mode in SAP HANA system replication?
Please choose the correct answer.
It takes place with continuous read-only access to the secondary system. It takes place every 5 minutes. It takes place in addition to continuous log shipping. It takes place in addition to continuous log replay.
Which services are located in a tenant database?
Please choose the correct answer.
Web Dispatcher Index server Name server Compile server.
Which types of backup can you use to copy an SAP HANA tenant database?
There are 2 correct answers to this question.
Delta database backup Full database backup Data snapshot Fallback snapshot.
Which actions take place during a database migration option (DMO) procedure when performing an in-place migration?
There are 2 correct answers to this question.
TABART is considered for the creation of R3load control files. De-pooling of tables is done during the procedure. One table is migrated per R3load pair. SAP up decides which tables to split.
Which table holds the data used for the dynamic management of partitions and locations?
Please choose the correct answer.
TABLE_GROUP TABLE_PLACEMENT UPDATE_LANDSCAPE_CONFIGURATION EFFECTIVE_TABLE_PLACEMENT.
Which tools do you use to delete diagnosis files?
There are 2 correct answers to this question.
SAP HANA cockpit SAP HANA cleaner SAP HANA Web-based Development Workbench SAP HANA database explorer.
You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system. Which of the following installation requirements are mandatory?
There are 2 correct answers to this questions.
The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added. The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
Which preparation tasks do you need to perform before starting the copy and move process for a tenant database?
There are 3 correct answers to this question.
Configure a secure connection from target system to source system. Create credentials for authenticated access to the target system. Create credentials for authenticated access to the source system. Backup the source tenant database. Create a tenant on the target system identical tothe source system.
Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)?
There are 3 correct answers to this questions.
Measurement of the data throughput between CPU and DRAM Measurement of the data throughput between SAP HANA nodes and storage Measurement of the data throughput between the Linux kernel and CPU Validation of the operating system configuration settings for the Linux kernel Validation of the LPAR configuration settings on IBM Power servers.
What additional action do you need to perform after you create a new tenant in an SAP HANA system replication configuration?
Please choose the correct answer.
Start the tenant database. Copy the tenant database. Restart the secondary system. Back up the tenant database.
Which prerequisites must you consider to add hosts to an SAP HANA scale-out system?
There are 2 correct answers to this question.
The additional host is placed in a different data center. The host has access to the installation directories. The SAP HANA database server is shut down. The SAP HANA system installation should be on a shared file system.
Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks?
Please choose the correct answer.
_SYS_TELEMETRY _SYS_STATISTICS _SYS_SL_ANALYZER _SYS_WORKLOAD_REPLAY.
Which activities do you have to carry out to configure your multi-tenant database container (MDC) system to a higher database isolation level between tenant databases on the operating system (OS)?
There are 3 correct answers to this question.
Add dedicated tenant OS users to the <sid> shm group. Create dedicated tenant OS users for each tenant. Remove the <sid> adm OS user from the sapsys group. Add dedicated tenant OS users to the sapsys group. Lock the adm OS user.
What is additional disk space factor required during delta merge operations?
Please choose the correct answer.
1.2 1.6 3.0 4.0.
What can you directly assign to a user with the Manage Users app in SAP HANA cockpit?
There are 2 correct answers to this question.
Roles Privileges Role collections Scopes.
Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration?
Please choose the correct answer.
On the additional Application Server (AAS) host On the source and target host On the remote target database host On the Primary Application Server (PAS) host.
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?
Please choose the correct answer.
End-to-End SQL Kernel profiler User-Specific.
The SAP HANA database system is not available through the SQL interface. Which option do you have to collect information to monitor connections, transactions, blocked transactions, and threads?
There are 2 correct answers to this question.
Troubleshot unresponsive systems PerfTrace.py Manage full system information dumps emergencyInfo.py.
Which system usage types are automatically assigned to ties in the SAP HANA cockpit?
There are 3 correct answers to this question.
Quality assurance Custom Development Test Production.
How can you perform a complete back up of an SAP HANA database system?
Please choose the correct answer.
Back up the system database and all tenant databases in one step. Back up the system database and all tenant databases individually. Back up the complete database system. Back up the complete storage system.
Which SAP HANA features can you use to manage the database peak load?
There are 2 correct answers to this question.
Thread throttling Workload classes Admission control Capture and replay.
Which default users will be created during the installation of the SAP HANA database system?
There are 2 correct answers to this question.
<sid>crypt sapadm sap<sid> ldapadm.
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting?
Please choose the correct answer.
The Observer Monitor The The R3LDCTL The Process Bucket monitor The Log viewer.
Which operating system process takes care of starting the SAP HANA database system services?
Please choose the correct answer.
sapstartsrv sapstart hdbrsutil hdbdaemon.
What is the purpose of the SAP HANA secure user store (hdb user store)?
There are 2 correct answers to this question.
To store connection information on the SAP HANA XS advanced engine To store connection information on the SAP HANA database client To configure an SAP HANA auto-restart for fault recovery To configure failover support in a 3-tier scenario.
Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface?
There are 2 correct answers to this question.
Installed SAP Host Agent on the SAP HANA host. Communication port 1129 is open. SAP HANA Client software locally installed. SAP HANA database system in any version.
Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?
Please choose the correct answer.
INFILE ADMIN WORKLOAD ADMIN DATABASE ADMIN RESOURCE ADMIN.
What can you assign to a user with the User Management app in SAP HANA cockpit?
There are 2 correct answers to this question.
LDAP authorization mode LDAP identity provider Scopes User group.
Which prerequisites must be fulfilled when recovering a tenant database?
There are 2 correct answers to this question.
You need the logon credentials of the system database user. You need the logon credentials of the <sid> adm user. The whole system is shut down, including all tenant databases. Before the recovery starts, the tenant database must be stopped.
What are the merge methods that are triggered by the SAP HANA system processes?
There are 2 correct answers to this question.
Auto Smart Hard Critical.
Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store?
There are 2 correct answers to this question.
SAP HANA tenant database replication Internal communication channels with the system PKI Client-server communication over JDBC HTTPS client access using the SAP HANA Web Dispatcher.
Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?
There are 2 correct answers in this question.
A cleanup has already been triggered. The DMO procedure hasn't reached downtime yet. The SUM folder needs to exist. The source database is up and running.
How can the system database administrator disable tenant database functionalities?
Please choose the correct answer.
Using the Manage Restricted Features app Using the hdbuserstore tool Using the resident hdblcm tool Using the Manage Blacklisted Parameter app.
What is prerequisite when you install the SAP Landscape Management tool?
Please choose the correct answer.
SAP HANA XS Advanced SAP NetWeaver Application Server Java SAP NetWeaver Application Server ABAP SAP Fiori launchpad.
How are hosts assigned to the shared storage in the SAP HANA scale-out system?
There are 2 correct answers to this question.
The standby node is assigned to the worker data volume. The master node is assigned to its own data volume. The master node is assigned to all log volumes. The worker nodes are assigned to their own data volumes.
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?
There are 2 correct answers to this question.
SPAM/SAINT ASAP Kernel ST-PI SAP Host Agent.
Which connection type is used by default for restricted users?
Please choose the correct answer.
ODBC OLEOS HTTP/S JDBC.
SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log?
There are 2 correct answers to this question.
record_limit queue_wait_time_threshold max_queue_size queue_timeout.
Which prerequisites must be fulfilled before adding hosts to an SAP HANA scale-out system?
There are 2 correct answers to this question.
The SAP HANA system installation is on shared file system. The SAP HANA database server is shut down. The host has access to the installation directories. The additional host is placed in a different data center.
What is the recomended size for the log volume file system for a 512 GB SAP HANA database system?
Please choose the correct answer.
614 GB 427 GB 256 GB 512 GB.
Which system privilege do you need to redistribute tables across the hosts in a scale-out system?
Please choose the correct answer.
DATA ADMIN WORKLOAD ADMIN OPTIMIZER ADMIN RESOURCE ADMIN.
How can you optimize the Database Migration Option (DMO) procedure downtime for a production system?
There are 2 correct answers to this question.
Use the benchmarking option to find the optimal throughput during the DMO procedure. Provide the measured table migration duration data for optimal table sequencing during benchmarking. Set the optimal number of R3load processes during benchmarking and the DMO procedure. Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.
Which preparation steps do you need to perform before replaying a captured workload using the SAP HANA capture and replay tool?
There are 3 correct answers to this question.
Restore the source system tenant backup to the target tenant. Store the logon credentials of the replayer user in the secure store. Create a replayer user account on the target operating system. Create a replayer user account in the target database system. Preprocess the captured workload on the source system.
You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?
Please choose the correct answer.
Moniitoring Repository Runtime Modeling.
What action(s) can you perform in the SAP HANA cockpit to back up the complete database system?
Please choose the correct answer.
Backup the system using a database snapshot and a data snapshot. Backup the system using a tailback snapshot for every database. Back up the system database and all tennant databases in one step. Back up the system database and all tenant databases individually.
Which system privileges are required for administering tenant databases when being connected to the system database?
There are 2 correct answers to this question.
MONITOR ADMIN DATABASE ADMIN BACKUP ADMIN DATA ADMIN.
Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?
There are 2 correct answers to this question.
Preprocessor Index server Compile server Daemon.
Which SAP HANA cockpit application can you use to investigate a system offline situation?
There are 2 correct answers to this question.
Full system information dumps Out-of-memory event monitor Troubleshot unresponsive system CPU usage monitor.
Which connections do you need to enable explicitly for a Restricted user?
There are 2 correct answers to this question.
ODBC JDBC OLEDB ADO.NET.
Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned?
Please choose the correct answer.
Balance table distribution Redistribute tables after adding host(s) Check the correct location of tables and partitions Check the number of partitions.
What is the correct sequence of the following four steps when you restart the SAP HANA database system?
Please choose the correct answer.
1. Row tables are loaded into memory.
2. Open transactions are recovered.
3. Aborted transactions are rolled back.
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. Aborted transactions are rolled back.
2. Open transactions are recovered.
3. Row tables are loaded into memory.
4. Column tables are loaded.
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?
Please choose the correct answer.
hdb backup diag hdb recover check hdb backup check hdb back int.
|
