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 the log segment is full When a commit occurs When the time threshold is exceeded When the log buffer is full.
Which SAP HANA cockpit application can you use to investigate a system offline situation? Full system information dumps CPU usage monitor Troubleshoot unresponsive system Out-of-memory event monitor.
What is a characteristic of the delta data shipping operation mode in SAP HANA system
replication? It takes place in addition to continuous log replay It takes place in addition to continuous log shipping It takes place every 5 minutes It takes place with continuous read-only access to the secondary system.
Who owns an SAP HANA Deployment Infrastructure (HDI) role? The user who created the role The SYS REPO technical user The SYSTEM user of the tenant database The container-specific technical user.
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 Manage Restricted Features app Using the Manage Database Configuration app Using the hdbuserstore tool.
Note: There are 3 correct answers A multitenant database container system is identified by a single system ID (SID) Database isolation increases the isolation between tenant databases on operating system level Each tenant database runs its own compile server and the preprocessor server. The name server owns information about the location of tables and table partitions in databases. The name server provides index server functionality for the system database.
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. DATABASE ADMIN SELECT on the SYS TELEMETRY schema CATALOG RAED SELECT on the SYS STATISTICS schema.
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 primary application server (PAS) can be moved to a target system landscape. A database migration from Oracle to SAP MaxDB can be performed. A database migration from SAP HANA to SAP ASE can be performed The SAP system can be AS Java-based if the release is 7.50 or higher.
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 MIGRATE DT DUR.XML file to optimize table splitting and migration sequence Use the Test Cycle option to determine the optimal number of R310ad processes. Use the UPGANA.XML analysis file to optimize the number of R310ad processes Use the MIGRATE SOT DUR.XML file to manually optimize table splitting of large tables.
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 tenant database is stopped The tenant database must be unloaded from memory The on-disk tenant directory should be a mount point The tenant database is not part of a move operation.
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. Btrfs OCFS2 GPFS XFS.
Which system usage types are automatically assigned to tiles in the SAP HANA cockpit?
There are 3 correct answers to this question. Quality assurance Test Development
Custom Production.
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 User group assignment Password policy configuration Role assignment.
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 check sum is generated every 10000 rows The content comparison is performed for repository tables. A row count is executed for the migrated tables The clustered tables are declustered.
Which connection type is used by default for restricted users? JDBC ODBC HTTP/S OLEDB.
Which system privilege must you have to restrict features for tenant databases in the SAP
HANA cockpit? WORKLOAD ADMIN INFILE ADMIN DATABASE ADMIN RESOURCE ADMIN.
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. Daemon Preprocessor Compile server Index server.
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? 1.5 TB 0.5 TB 2.0 TB 1.0 TB.
You want to implement a 28-day backup cycle. Which scenario uses the least storage? Full backup, incremental backup, log backu Full backup, log backup Incremental backup, log backup Full backup, differential backup, log backup.
Which preparation tasks do 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 Back up the source tenant database Configure a secure connection from target system to source system Create a tenant on the target system identical to the source system.
Which tools are integrated into the SAP HANA cockpit?
Note: There are 3 correct answers SQL Analyzer HDBAdmin HANASitter SQL Console
Database Explorer.
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 additional host is placed in a different data center The SAP HANA database server IS shut down.
The host has access to the Installation directories.
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. ASYNC SYNCMEM FULL SYNC SYNC.
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 SAP Host Agent SPAM/SAINT ST-PI ABAP Kernel.
Which hardware KPIs do you need to size before performing a tailored data centerintegration (TDI) installation for a productive SAP HANA database system.
Note: There are 2 correct answers to this question. Network bandwidth for the storage zone Total disk space required for the log volume Persistent memory (PMEM) required for backups DRAM required for the static data memory area.
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. Uninstall the SAP HANA database system and its components Rename the SAP HANA database system. Update the SAP HANA database system and its components. Extract the SAP HANA database system components.
Which table holds the data used for the dynamic management of partitions and locations. TABLE GROUP UPDATE LANDSCAPE CONFIGURATION TABLE PLACEMENT EFFECTIVE TABLE PLACEMENT.
What is the correct sequence of the following four steps when you restart the SAP HANA database system? 1. Row tables are loaded into memory.
2. Column tables loaded
3. Open transaction 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 loade 1. Aborted transactions are rolled back
2. Open transactions are recovered
3. Row tables are loaded into memory.
4. Column tables are loaded C. 1. Aborted transactions are rolled back
2. Open transactions are recovered
3. Row tables are loaded into memory.
4. Column tables are loaded.
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 file system locations do 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 A. /hana/shared B. /usr/sap/hostctrl >/ C. /hana/log/<SID> D. /usr/sap/<SID>.
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).
What is the recommended size for the log volume file system for a 512 GB SAP HANA
database system?
A. 614 GB B. 256 GB C. 512 GB D. 427 GB.
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.
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. A. Activation of dictionary objects in phase ACT UPG B. XPRAS execution in phase XPRAS AIMMRG C. Migration of application tables in phase EL) CLONE MIG DT RUN D. Creation of application tables in the target database in phase EU CLONE MIG DT CREATE.
Which rules should 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. A. Keep the number of partitions per table high.
B. Keep all partitions on different hosts C. Keep the number of partitioned tables low D. Keep the number of key columns low.
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 tenan.
Which prerequisites of the primary system and the secondary system are mandatory before
can activate SAP HANA system replication with secondary time travel?
Note: There are 2 correct answers to this question. A. An explicit read-only connection between both systems must be available. B. Both must have the same SAP HANA version. C. The CPU architecture must be identical. D. Both systems are located in the same data center.
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.
NO.41 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 file.
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 operating system process takes care of starting the SAP HANA database system
services?
A. hdbrsutil B. sapstartsrv C. hdbda emon D. sapstart.
Which feature do you use to dynamically manage SAP HANA database workloads per client session?
A. Workload classes B. Admission control C. Parallel execution of SQL statements D. Non-Uniform Memory Access (NUMA).
How can you ensure that a consistent database status is saved using data snapshots?
A. Trigger a savepoint. B. Create a fallback snapshot C. Execute the hdbbackupdiag tool D. Create an internal database 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.
A. The master node is assigned to its own data volume. B. The master node is assigned to all log volumes C. The worker nodes are assigned to their own log volumes D. The standby node is assigned to the worker data volume.
NO.47 You are checking and monitoring SAP HANA system replication
Which status indicates a temporary connection loss of the secondary system?
A. Unknown B. Error C. Initializing D. Syncing.
NO.48 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.
NO.49 You are planning an SAP S/4HANA scale-out system
What are the minimal size requirements for CPU and memory?
A. RAM: >= 4TB, CPU: > = 8 B. RAM: >= 6TB, CPU: >=8 C. RAM: >= 8TB, CPU: > = 12 D. RAM: >= 6TB, CPU: > = 12.
NO.50 During the delta merge process, to which memory areas is data inserted? Note: There are 2
correct answers to this question.
A. Main 2 B. Main 1 C. Delta 2 D. Delta 1.
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.
NO.52 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 A. One table is migrated per R3load pair B. De-pooling of tables is done during the procedure. C. TABART is considered for the creation of R3load control files. D. SAPup decides which tables to split.
NO.53 How does SAP HANA encrypt the data persistence layer?
A. By column level B. By page level C. By table level D. By row level.
NO.54 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.
A. Password of user sapadm B. SAP HANA System ID (SID) C. Data and log path D. Installation path.
NO.55 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.
A. Tracking B. In-memory tracing C. Statement memory limit D. Memory tracking.
NO.56 For an SAP HANA tailored datacenter integration (TDI) approach, what is the additional disk
space factor required during delta merge operations?
A. 3.0 B. 1.6 C. 2.0 D. 1.2
.
NO.57 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.
NO.58 Which role do you need in order to assign users to groups in the SAP HANA cockpit A. Cockpit user Role
B. Cockpit user Administrator Role C. Cockpit Database Administrator Role D. Cockpit Administrator Role.
NO.59 Which tool shows information about the list of tables to be pre-loaded during an SAP HANA
system start?
A. sapcontrol B. HDBAdmin C. hdbcons D. RecoverStateChecker.py.
NO.60 Which system privilege do you need to redistribute tables across the hosts in a scale-out
system?
A. optimizer admin B. data admin C. resource admin D. workload admin.
NO.61 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 provide.
NO.62 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.
Which properties can you adjust in SAP HANA admission control?
Note: There are 3 correct
answers to this question.
A. Memory threshold for queuing new requests B. CPU threshold for rejecting new requests C. Maximum queue size for requests D. Maximum number of parallel 10 requests E. Memory limits for new SQL statement request.
NO.64 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.
NO.65 Which feature do you configure to prevent the whole SAP HANA database system from
reaching physical processing limits?
A. Workload classes B. Capture and replay C. Performance trace D. Admission control.
NO.66 Which actions can you perform using the SAP HANA platform lifecycle management web user
interface?
Note: There are 2 correct answers to this question.
A. Configure the system landscape directory registration. B. Manage the full system information dumps. C. Update the SAP HANA database system D. Stop and start the SAP HANA database system.
NO.67 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.
NO.68 What do need in a multitenant database container (MDC) system to run queries across
tenant databases? Note: There are 2 correct answers to this question.
A. The user in the source system must be associated with a user in the target database. B. The cross-tenant database communication must be explicitly activated
C. The bidirectional communication channel must be whitelisted. D. The user in the source system must have sufficient privileges in the target database.
NO.69 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?
A. hdbbackupdiag B. hdbrecovercheck C. hdbbackupcheck D. hdbbackint.
NO.70 How are user group administrators and user groups related? Note: There are 2 correct
answers to this question.
A. Multiple user group administrators per user group B. Only one user group per user group administrator C. Multiple user groups per user group administrator D. Only one user group administrator per use.
NO.71 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.
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.
A. Troubleshoot unresponsive systems B. PerfTrace.py C. emergencylnfo_py D. Manage full system information dump.
NO.73 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.
NO.74 Which technology is used to install the SAP Landscape Management tool?
A. SAP Fiori launchpad B. SAP NetWeaver Application Server for Java C. SAP HANA XS advanced runtim D. SAP NetWeaver Application Server for ABAP.
NO.75 Which SAP HANA trace must you activate to analyze performance issues with systems where
third-party software cannot be installed?
A. End-to-end B. Kernel profiler C. SQL D. User-specific.
NO.76 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.
NO.77 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?
A. The reading processes run on the source database host; the writing processes run on the target
database host. B. All of the reading and writing processes run on the target database host C. The reading processes run on the primary application server (PAS) host; the writing processes run
on the target database host. D. All of the reading and writing processes run on the primary application server (PAS) host.
NO.78 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. TENANT ADMIN C. BACKUP ADMIN D. DATABASE ADMIN.
NO.79 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.
A. <sid>adm B. sap<sid> C. Database User D. Cockpit user E. Root.
NO.80 What cryptographic libraries are supported in SAP HANA by default? Note: There are 2
correct answers to this question.
A. Libgcrypt B. CommonCryptoLib C. OpenSSL D. wolfCrypt.
Answer: B,C
NO.81 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.
NO.82 What are the merge methods that are triggered by the SAP HANA system? Note: There are 2
correct answers to this question.
A. Smart B. Critical C. Forced D. Auto.
Which schema provides performance data and alert details to review in SAP HANA mini COCKPIT MONITOR SYS SQL ANALYZER SAP XS USAGE SYS STATISTICS.
|
