Which role do you need in order to assign users to groups in SAP HANA cockpit? Cockpit User
Cockpit Administrator
Cockpit Resource Administrator
Cockpit User Administrator
.
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting?
The Log viewer
The R3LDCTL The Process Bucket monitor
The Observer Monitor
.
Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? (2 Correct)
statement_memory_limit
total_statement_memory_limit
memory_tracking
reject_memory_threshold
.
How can the system database administrator disable tenant database functionalities?
Using the Manage Restricted Features app
Using the resident hdblcm tool
Using the hdbuserstore tool Using the Manage Blacklisted Parameter app
.
Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? (2 Correct)
The Primary Application Server can be moved to a target system Landscape.
The source and target database system are of the same type.
The target database is SAP Adaptive Server Enterprise (ASE).
The source system is Application Server (AS) Java-based.
Which is the relationship between the user group operators and the user groups? (2 Correct)
Only one user group operator per user group
Multiple user groups per user group operator
Only one user group per user group operator
Multiple user group operators per user group
.
Which tools do you use to delete diagnosis files? (2 Correct)
SAP HANA database explorer
SAP HANA cockpit
SAP HANA Web-based Development Workbench
SAP HANA cleaner
.
Which prerequisites are necessary for productively using SAP HANA cockpit 2.0? (2 Correct)
10 GBit/s network bandwidth
An IBM Power System with operating system SUSE Linux Enterprise Server (SLES)
16 GB RAM on a dedicated server
An Intel-based system with operating system Microsoft Windows
.
Which connections do you need to enable explicitly for a Restricted User? (2 Correct)
OLEDB JDBC ODBC ADO.NET
.
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? (2 Correct)
The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.
The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
.
What are the merge methods that are triggered by the SAP HANA system processes? (2 Correct)
Hard
Critical Smart Auto
.
Which SAP HANA database service can you stop from the system database? (2 Correct)
Preprocessor
Compile server Index server
XS Engine
.
Who owns an SAP HANA Deployment Infrastructure (HDI) role?
The container-specific technical user
The user who created the role
The _SYS_REPO technical user
The SYSTEM user of the tenant database
.
In a Multiple Database Container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases?
BACKUP ADMIN
DATABASE ADMIN
BACKUP OPERATOR
TENANT ADMIN
.
SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems?
An upgrade of the primary system
An upgrade of the secondary system
A restart of the secondary system
A restart of the primary system
.
In which scenario do you need SAP expert sizing? (2 Correct)
Customers are new to SAP applications and SAP HANA
Carving out ERP functionality from the source system to the ERP on SAP HANA system.
Consolidating multiple ERP source systems into one ERP system on SAP HANA
Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA.
What is the additional disk space factor required during delta merge operations?
4 1.2 3 1.6.
Which backup and recovery scenario is allowed in multitenant database containers?
A backup of a tenant database can be recovered to the system database.
A tenant database can initiate its own backup, but the system database executes the recovery.
After the recovery of a tenant database, the system database needs a backup.
The system database should be recovered first in order to recover the tenant databases.
.
Which database objects can you manipulate if you have the ALL PRIVILEGES activity? (2 Correct) Views Sequences Procedures Tables
.
What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication?
Delta data shipping takes place every 5 minutes.
Delta data shipping takes place in addition to continuous log shipping.
Delta data shipping takes place with continuous read-only access to the secondary system.
Delta data shipping takes place in addition to continuous log replay.
.
What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system?
For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB
For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB
For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB
For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB
.
What are the supported operating systems for SAP HANA on IBM Power Servers? (2 Correct)
For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2
For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10
For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15
For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4
.
Which SAP HANA cockpit application can you use to investigate a system offline situation? (2 Correct)
Full system information dump
Out-of-memory event monitor
Troubleshoot unresponsive system
CPU usage monitor
.
Which file system locations are suggested to install an SAP HANA multi-host system? (2 Correct)
/hana/<hostname>
/hana/<sid>
hana/log/<sid>
/hana/shared
.
Which parameters do you need to change before you can analyse the memory usage of running SQL statements? (2 Correct)
statement_memory_limit
use_in_memory_tracing
memory_tracking enable_tracking.
Which system privileges are required for administrating tenant databases when being connected to the system database? (2 Correct)
ADMIN DATABASE ADMIN
MONITOR ADMIN
BACKUP ADMIN
.
Which system privilege must you have to redistribute tables across the hosts in your scale-out system?
WORKLOAD ADMIN
RESOURCE ADMIN
OPTIMIZER ADMIN
DATA ADMIN
.
Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned?
Check the correct location of tables and partitions
Redistribute tables after adding host(s)
Check the number of partitions
Balance table distribution
.
Which prerequisites must you consider to rename a tenant database in the SAP HANA cockpit? (2 Correct)
The on-disk tenant directory should be a mount point.
The database that is not in move operation.
The tenant database is stopped.
The tenant database must be unloaded from memory.
.
Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface? (2 Correct)
Communication port 1129 is open.
SAP HANA Client software locally installed. SAP HANA database system in any version.
Installed SAP Host Agent on the SAP HANA host.
.
Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? (3 Correct) 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.
.
How are hosts assigned to the shared storage in an SAP HANA scale-out system? (2 Correct)
The standby server is assigned to the master data volume.
The master name server is assigned to its master data volume.
The master server is assigned to all data volumes.
The slave servers are assigned to their own data volumes.
.
You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system? Initializing Error
Unknown Syncing
.
Which prerequisites must you consider to add hosts to an SAP HANA scale-out system? (2 Correct)
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 table provides a customizing interface that can be used for the dynamic management of partitions and locations? TABLE_PLACEMENT TABLE_GROUP EFFECTIVE_TABLE_PLACEMENT UPDATE_LANDSCAPE_CONFIGURATION.
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? (2 Correct)
The cross-tenant database communication must be explicitly activated.
The user in the source system must be associated with a user in the target database. The user in the source system must have sufficient privileges in the target database.
The bidirectional communication channel must be whitelisted.
.
Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? (2 Correct)
Keep the number of partitioned tables low.
Keep all partitions on different hosts.
Keep the number of partitions per table high.
Keep the number of key columns low.
.
The data storage of your productive SAP HANA instance crashed, and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss?
The last full data backup
The latest log backup
The last commited transaction
The latest incremental backup
.
How are savepoints triggered? (2 Correct)
By performing a delta merge.
By issuing a transactional commit.
By a database soft shutdown.
By performing a database backup.
Which types of backups can you use to copy an SAP HANA tenant? (2 Correct) Full database backup Delta database backup
Data snapshot
Fallback snapshot
.
|
