You register a new resource in SAP HANA cockpit 2.0.
What prerequisite does the resource require?
- A . A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema
- B . A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema
- C . A multitenant configuration with SYSTEMDB
- D . The target database on SAP HANA 2.0 SPS00 or higher
What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.
- A . The database is renamed
- B . The directories are renamed
- C . The backups are renamed
- D . The logs are renamed
Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.
- A . CATALOG READ
- B . USER ADMIN
- C . DATA ADM IN
- D . ROLE ADMIN
Which information is provided by the backup catalog. Please choose the correct answer.
- A . Backup destination
- B . Progress of a backup
- C . Backup configuration
- D . Backup ID
The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.
- A . The role name
- B . The privileges assigned to the role
- C . The users assigned to the role
- D . The users assigned by default to this role
Which SAP recommendations do you follow to create an optimal table partitioning plan for SAP Business Suite powered by SAP HANA? Note: There are 2 correct answers.
- A . Have a high number of partitions per table
- B . Have a low number of keys
- C . Have partitions of a table on the same host
- D . Have a high number of partitioned tables
Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.
- A . Restore the source tenant backup into the target tenant
- B . Start the replayer on the source system
- C . Create the replayer user in the control system
- D . Create a secure store key on the control system host
Which authentication method can you configure for single sign-on in a middleware/application server scenario.
- A . JSON web token
- B . SAML
- C . Kerberos
- D . X.509 certificate
Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers.
- A . Backup
- B . Data
- C . Log
- D . Pages in-memory
- E . Storage snapshot
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.
- A . Create credentials for authenticated access to the source system.
- B . Create a tenant on the target system identical to the source system.
- C . Back up the source tenant database.
- D . Configure a secure connection from target system to source system.
- E . Create credentials for authenticated access to the target system.
During the delta merge process, to which memory areas is data inserted? There are 2 correct Answers to this question.
- A . Delta 2
- B . Main 2
- C . Delta 1
- D . Main 1
Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?
- A . DBA Cockpit
- B . hdblcm
- C . hdbsql
- D . SAP HANA cockpit
You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup? Note: There are 2 correct answers.
- A . When a savepoint occurs
- B . When the log buffer is full
- C . After the configured time threshold has been exceeded
- D . When the log segment is full
Which tools can you use to monitor the response time of individual SQL queries? Note: There are 2 correct answers.
- A . SQL Trace
- B . Statement Monitor
- C . SQL plan cache
- D . Thread Monitor
You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory allocated and service 2 has 40 GB allocated.
What is the effective allocation limit of service 3?
- A . 100 GB
- B . 90 GB
- C . 35 GB
- D . 25 GB
You plan to set up an SAP HANA2.0 system on intel-based hardware platform.
Which of the following operating systems can you use ? Note: There are 2 correct answers
- A . Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2
- B . SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1
- C . SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1
- D . Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5
Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.
- A . Feature Package Stack
- B . Datacenter Service Point
- C . Support Package
- D . Support Package Stack
Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?
- A . Manage Databases
- B . Manage Services
- C . Resource Directory
- D . Performance Monitor
You upgrade an SAP HANA 1.0 system to SAP HANA 2.0.
Which of the following activities are required to avoid compatibility issues after the upgrade? Note: There are 2 correct answers.
- A . Export the backup jobs history from SAP HANA 1.0 and import the history after the upgrade
- B . Delete all Backup schedules with the SAP HANA cockpit 1.0
- C . Create new backup schedules after the upgrade
- D . Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules
How can you minimize the database migration option (DMO) downtime?
- A . Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3 load processes
- B . Use the benchmarking tool for a productive database migration with the DMO procedure
- C . Provide the measured table migration duration for table sequencing during benchmarking
- D . Adjust the number of R3load processes during benchmarking and the DMO procedure
Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers.
- A . SAP HANA cockpit 2.0 – Manage Databases
- B . hdbsql
- C . SAP HANA Studio – System view
- D . sapcontrol
What can a user do when the backup operator system privileges is assigned?
- A . Perform data recovery
- B . Schedule backups
- C . Delete backups
- D . Configure backup settings
What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring
tool for productive SAP HANA databases?
- A . A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES)
or Red Hat Enterprise Linux (RHEL) - B . A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed
- C . A central SAP HANA database 2.0 SPS02 multitenant database system with at least 16 GB of RAM
- D . SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed
Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.
- A . The same number of active hosts and standby hosts must be installed
- B . Both must have the same SAP HANA version
- C . An explicit read-only connection between both systems must be available
- D . The CPU architecture must be identical
logical error occurred in one tenant of your SAP HANA database.
What action do you perform to make the tenant consistent again? Please choose the correct a nswer
- A . Recover the affected tenant. The system database is NOT recovered.
- B . Recover the system database first and then recover the affected tenant.
- C . Recover the affected tenant first and then recover the system database.
- D . Recover the system database. The affected tenant is recovered automatically.
Which diagnostic file can you use to monitor the status of database recovery?
- A . backint.log
- B . backup.log
- C . sapstartsrv.log
- D . available.log
After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?
- A . It determines and rolls forward aborted transactions
- B . It rolls back write transactions that were open when the database was stopped
- C . It reloads a savepoint with the restored consistent state of the database
- D . It rolls back changes of committed transactions that were NOT written to the data area
Which tool do you use to backup the root encryption keys?
- A . rsecssfx
- B . hdbuserstore
- C . dbacockpit
- D . hdbnsutil
Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.
- A . CREATE ANY
- B . EXPORT
- C . EXECUTE
- D . CREATE SCHEMA
- E . DEVELOPMENT
Which trace do you use to create a graphical representation of an individual SQL Statement?
- A . Performance trace
- B . Expensive statements trace
- C . SQL trace
- D . Plan trace
One of your systems show the internal Disk Full (Alert 30) alert.
What is the root cause of this alert?
- A . Reading from the /hana/log/<sid> volume is NOT possible
- B . Writing to the /hana/data/<sid> volume is NOT possible
- C . Runing out of free space on the /hana/shared volume
- D . Exceeding system quota on the /usr/sap volume
Which information is provided via the SUM Ul? There are 3 correct answers to this question.
- A . The active roadmap step
- B . The content of log files via the log viewer
- C . The memory consumption of SUM
- D . A progress bar for the overall procedure
What are advantages of column store tables? There are 3 correct answers to this question.
- A . Columns can be partitioned
- B . Only the columns required are actually loaded to memory
- C . They are optimized for high-volume read /write transactional processing
- D . Data footprint is automatically reduced through compression
Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system.
Which of the following options are listed? There are 3 correct answers to this question.
- A . Monitoring and Administration
- B . Performance Management
- C . Resource Management
- D . Security
- E . Memory Management
Your SAP HANA database is locked down.
Which action can you still perform?
- A . Check database license
- B . Check overall database status
- C . Check session memory
- D . Configure system properties
Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.
- A . Cockpit User Administrator
- B . Cockpit User
- C . Cockpit Resource Administrator
- D . Cockpit Administrator
Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question.
- A . Migrating to a target database, g. SAP HANA
- B . Performing an SAP software update
- C . Performing a Unicode conversion
- D . Performing a database upgrade of the source database
Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? There are 2 correct answers to this question.
- A . SYNCMEM
- B . FULL SYNC
- C . SYNC
- D . ASYNC
Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.
- A . SLAVE
- B . STANDBY
- C . WORKER
- D . MASTER 1
The SAP HANA database is NOT reachable, and the root cause is unclear.
Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.
- A . Troubleshoot unresponsive system
- B . Overall database status
- C . Manage full system information dumps
- D . Open blocked transactions