Which system privileges do you require to view roles that are granted to other users?
Note: There are 2 correct answers to this question CATALOG READ ROLE ADMIN USER ADMIN DATA ADMIN.
Your SAP HANA database is locked down.
Which action can you still perform from the SAP HANA cockpit 2.0? Check session memory Configure System Properties Check database license Check overall database status.
Which actions are always recorded when Auditing is active?
Note: There are 2 correct answers to this question Modification of an audit policy Create or drop user Grant or revoke roles Disable Auditing.
What must you do to convert in SAP HANA 1.0 single database system to a SAP HANA 2.0 multitenant database system? Upgrade the SAP HANA database system Export/Import application and customer data Create the system database manually Execute the SUM database migration option with system move.
You plan to set up na SAP HANA 2.0 system on Intel-based hardware platforms.
Which of the following Operating systems can you use?
Note: There are 2 correct answers to this question SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1 SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1 Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5 Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2.
Which upgrade methods can you use to minimize the business downtime during the upgrade of an SAP HANA database?
Note: There are 2 correct answers to this question Database migration option of SUM Phased Update Near-Zero Downtime Export/Import using Sap Software Provisioning Manager.
Which backup scenarios are allowed in multitenant database containers?
Note: There are 2 correct answers to this question A tenant database can initiate its own backup unless this is prohibited by the system configuration The system database should be recovered first in order to recover the tenant database The system database can initiate its own backup and the backup of tenant databases A backup of tenant database can be recovered to a SAP HANA single-container system.
You perform a SAP HANA migration to a scale-out landscape.
When do you set up the table distribution rules? After the migration After table creation Before Table Creation Before the Migration.
How do you ensure that Web-based applications send HTTPS requests to specific databases in a SAP HANA multiple-container system?
Note: There are 2 correct answers to this question Check the hostnames mapping to internal HTTPS ports Configure an alias hostname for every tenant database Check that all requests with a physical hostname are forwarded to tenant databases Configure an SAP Web Dispatcher for every tenant database.
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 to this question. When a savepoint occurs When the log buffer is full When the log segment is full After the configured time threshold has been exceeded.
Which encryption services can you activate in SAP HANA?
Note: There are 3 correct answers to this question. Backup Storage Snapshot Data Log Pages in-memory.
Wich information is stored in the SYSTEMDB of na SAP HANA multitenant database container system?
There are 2 correct answers for this question. landscape topology data on the system as a whole. Topology data on the location of tables partitions. Users and authorizations of the SYSTEMDB and all tenant databases. Monitoring data on the SYSTEMDB and all tenant database.
You need to periodically monitor if the SAP HANA primary system is online.
Which tool do you use? systemreplicationStatus HDBAdmin landscapehostconfiguration hanasitter.
You register a new resource in SAP HANA cockpit 2.0
What prerequisite does the resource require? A multitenant configuration with SYSTEMDB. The target database on SAP HANA 2.0 SPS00 or higher A user with DATA ADMIN privilegie and SELEC on _SYS_TELEMETRIC schema A user with CATALOG READ privilegie and SELECT on _SYS_STATISTIC schema.
You set upe mail notification for a specific alert threshold by using alerts configuration.
When are the email notification sent?
Note: There are 2 correct a answers to this question. When the alert checker identifies a recurring issue When the alert Checker identifies a resolved issue When the alert Checker is turned off When the alert Checker identifies na issue.
One of your systems shows the Internal Disk Full (Alert 30) alert.
What is the root cause of this alert? Running out of free space on the /hana/shared volume. Reading from the /hana/log/<sid> volume is NOT possible. Exceeding system quota on the /usr/sap volume Writing to the /hana/log/<sid> volume is NOT possible.
Which dianostic file can you use to monitor the status of database recovery? sapstartsrv.log backup.log available.log backint.log.
Which authentication method can you configure for single sign-on in a midlleware/ application server scenario? SAML Kerberos X509 Certificate JSON web token.
How can you shorten the delta merge runtime of a table?
Note: There are 2 correct answers to this question. Fully load the delta store into memory. Partition the table Merge per column Perform memory-only delta merges.
Which removal statuses allow you to remove a host from na SAP HANA scale-out landscape?
Note: There are 2 correct answers to this question. Reorg finished Reorg active Reorg pending Reorg not required.
What can a user do wheren the backup opteror system privilegie is assigned? Configure backup settings Perform data recovery Delete backups schedule backups.
What do you do to prepare the database migration option of a Software Update Manager procedure?
Note: There are 3 correct answers to this question. Move the stack.xml update file into the download. Move the SPAM update archive into the download folder Extract the SAP Hana client installation archive. Extract the SAP HANA database installation archive. Move the R3trans update archive into the download folder.
Which partitioning option distributes rows equally for load balancing in the SAP HANA Database? Range-Range Hash Range RoundRobin.
You investigate a hung SAP HANA database, and you CANNOT identify the blocking transactions.
What causes could lead to this behavior?
Note: There are 2 correct answers to this questions. Long savepoint duration A setting to restrict CPU usage. A wrong role of a service in a failover situation. An issue with the delta merge.
The SAP HANA database is NOT reachable, and the root cause is nuclear Which SAP HANA cockpit functions allow you to investigate this situation?
Note: There are 2 correct answers to this question. Open blocked transactions Manage full system information dumps. Troubleshoot unresponsive system Overall database status.
Which activities mus you perform before you can replay a workload using the capture and replay application?
Note: There are 2 correct answers to this question. Create the replayer user in the control system Create a secure store key on the control system host. Start the replayer on the source system Restore the source tenant backup into the target tenant.
You need to analyze the high CPU load of running threads in more detail in the Thread Monitor.
Which parameters do you need to change?
Note: There are 2 correct answers to this question. load_monitor_granularity enable_tracking threshold_cpu_time cpu_time_meassurement_mode.
Which of the following tasks can you perform using the residente SAP HANA database lifecycle manager (HDBLCM)?
Note: There are 3 correct answers to this question. Rename the SAP HANA database hostname. Transport application changes. Unistall the individual componentes. Remove host roles. Rename the SAP HANA database system.
You define the parameters for the password policy of na SAP HANA tenant database.
Where área these parameters stored? Multidb.ini indexserver.ini nameserver.ini global.ini.
Which trace do you use to create a graphical representation of na individual SQL statement? SQL trace Performance trace Plan trace Expensive statements trace.
A technical user is required when you register a SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system privilegie do you assign to the technical user account on the target system? User Admin Catalog read Data Admin Monitor Admin.
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 to this question. The same number of active hosts and standby host must be installed. The CPU architecture must be identical. Both must have the same SAP HANA Version An explicit read-only connection between both systems must be available.
Which certificates do you require for a trusted secure communication between the cliente and the SAP HANA database?
Note: There are 2 correct answers to this question. Server certificate Root certificate User certificate x.509 certificate
Which SQL Privilege can you grant to another user? DATA ADMIN CATOLOG READ ATTACH DEBUGGER CREATE SCHEMA.
Which tool do you use to back up the root encryption Keys? rsecssfx dbacockpit hdbnsutil hdbuserstore.
You need to integrate na existing SAP HANA 2.0 SPS 03 database system into the SAP HANA cockpit monitor infrastructure.
Where do you create the technical user needed for the resource registration? In the SYSTEMDB and the first tenant. In the SYSTEMDB and all tenant. In the first tenant. In the SYSTEMDB.
Why are repositor roles prefere over catolog roles?
Note: There are 2 correct answers to this question. They are transporte runting objects They are revoked if the database user that granted them is deleted They are transportable design-time objects. They are created by the techinical user.
You upgrade na 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 to this question. Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules. Export the backup Jobs history from SAP HANA 1.0 and import the history after the upgrade. Create new backup schedules after the upgrade. Delete all backup schedulles with the SAP HANA cockpit 1.0.
Which application do you use to reset memory statistics before you analyze a tenant database using SAP HANA cockpit? Resource Directory Performance Monitor Manage databases Manage Services.
Which tools can you use to monitor the response time of individual SQL Queries?
Note: There are 2 correct answers to this question Statement Monitor SQL Plan cache Thread Monitor SQL trace.
Which tools can you use to start and stop tenants in na SAP HANA database?
Note: There are 2 correct answers to this question. sap control SAP HANA studio SAP HANA cockpit 2.0 – Manage Databases hdbsql.
Why does SAP HANA have a persistence storage layer that is disk-based?
Note: There are 2 correct answers to this question. To persist in-memory data To enable database scale-up to allow a restart if the power fails to ensure maximum performance.
Wich tools can you use to start and stop SAP HANA Database?
Note: There are 3 correct answers to this question. DBA Cockpit SAP HANA application life cycle management [HDBCLM] SAP HANA cockpit HDB command SAP Control.
Which target databases does the SUM database migration option provide by default?
Note: There are 2 correct answers to this question. SAP IQ SAP MaxDB SAP ASE SAP HANA .
Which information can you analyze using troubleshooting Unresponsive System Application? Alerts count CPU utilization SYSTEM Availability Thread status.
How can you minimize the Database Migration Option (DMO) downtime? Provide the measured table migration duration for table sequencing during benchmarking Use the benchmarking tool for a productive database migration with the DMO procedure Adjust the number of R3load processes during benchmarking and the DMO procedure Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes.
You install a productive multi-host system with failover capabilities.
Which storage conditions prerequisites must be ensured?
Note: There are 2 correct answers to this question The failed worker host no longer has access to write to file The failed worker host has access to write to files The standby host has file access The standby host has NO file access.
Which SAP HANA features ensure that committed data is NOT lost if there is a power failure?
Note: There are 2 correct answers to this question. Automatic savepoints Persisted redo logs Delta merge Undo logs.
What must you do to configure the data backup on a scale-out SAP HANA systems?
Note: There are 2 correct answers to this question. Change the backup configuration for each mode Specify the individual backup destination on each node. Verify that data and log backup destinations are valid throughout file system Ensure the availability os shared backup storage for all nodes.
Which of the following system privileges can you assign to an SAP HANA database user?
Note: There are 3 correct answers to this question. CREATE ANY EXECUTE CREATE SCHEMA DEVELOPMENT EXPORT.
You need to update the location where a copy of the persistent data is saved.
Wich of the following parameters do you change?
Note: There are 2 correct answers to this question. basepath_databackup basepath_logmirror basepath_export basepath_logbackup.
The network security policies of your project restrict direct SQL connections to the SAP HANA databases.
Wich tools can you use to monitor the SAP HANA database?
Note: There are 2 correct answers to this question. SAP HANA Data Management Studio SAP HANA cockpit SAP Landscape Management SAP Solution Manager.
What do you require to perform a migration using the SUM database migration option?
Note: There are 2 correct answers to this question. Migration check service OS/DB certified consultant Migration Key Stack xml file.
What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping?
Note: There are 2 correct answers to this question. CPU load is reduced Memory consumption is lower Network traffic is reduced Takeover time is shorter.
Wich information is recorded in the database trace of the SAP HANA database? Database activities with trace level ERROR Executed SQL statements on database level Query execution plans on an application level Performance indicators on a query level.
What is a characteristic of the synchronous in-memory systems replication model in SAP HANA? The primary system waits the secondary system confirms receiving the log The primary system suspends transactions processing until the connection to the secondary system is re-estabilished The primary system does NOT wait for the confirmation of the secondary system The primary system waits until the secondary system confirm the log was persisted.
Which R3load node is used during an inplace SUM database migration option procedure? Socket File Pipe Network.
Which programming languages are supported when you develop an application on SAP HANA extended application services?
Note: There are 2 correct answers to this question. Lisp.js C++ ABAP Node.js.
Wich action do you perform when the data area in an SAP HANA database is running out of space? Extend the size of the database volume Extend the file system size on the operating system level Create a new tenant database Create a new database volume.
Which operations area performed by SAP Landscape Management?
Note: There are 2 correct answers to this question. It automizes repetitive, time-intensive administration tasks It simplifies the management of SAP hybrid landscapes and standardizes SAP operations It replicates the storage in an SAP Landscape It de-centralizes landscape operations and provides a local landscape view.
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 to this question. Have a high number of partitions per table Have partitions of a table on the same host Have a low number of key colunns Have a high number of partitioned tables.
You administer a single-host system with 100 GB physical memory. The global allocation limit and the individual service allocation are set to 90%.
Three services are running Service 1 has 25 GB of memory allocated and service 2 has 40 GB allowed.
What is the effective allocation limit of service 3? 25 GB 35 GB 90 GB 100 GB.
After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode? It rolls back changes of committed transactions that were NOT written to the data area. It reloads a savepoint with the restored consistent state of the database. It rolls back write transactions that were open when the database was stopped. It determines and rolls forward aborted transactions.
What is a prerequisite before you can install SAP HANA cockpit 2.0 as a central monitoring tool for a productive SAP HANA database? A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL) SAP Netweaver 7.5x on SAP Hana 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed A central SAP HANA 2.0 SPS02 multitenant database system with at least 16 GB RAM.
You installed an SAP Netweaver-based application on an SAP HANA database.
What is the default secure user store to store the password of the SAP<schema-id> user? hdbuserstore xuser Secure store in the system (SSFS) ABAP secure store file system (SSFS).
Which tool shows the differences of tables and indexes between your ABAP dictionary and your SAP HANA database? SAP HANA Cockpit hdblcm DBA cockpit hdbsql.
Due to hardware failure of your persistence area, your HANA database needs to be restored.
Which tasks do you perform to recover the complete system?
Note: There are 2 correct answers to this question. Recover all the databases using the initialize log area option Start the recovery from the tenant databases using HANA cockpit 2.0 Recover the system database before recovering all tenant databases Start the recovery from the system database using SAP HANA cockpit 2.0.
Which script can you trigger from SAP HANA cockpit to collect diagnosis information? hanadumpviewer.py hanachecker.py fullSysteminfoDump.py HanaHrCheck.py.
You are installing several SAP HANA systems with a standard setup.
How can you automate this activity? Export and Import the standard configurations from SAP HANA cockpit Copy the ini files to all the systems Copy the complete install folders to all the systems Generate a configuration template using hdblcm.
In Which replication mode is the primary system blocked until the secondary system is available? async Full sync Syncmem Sync.
Which operation is executed before a table is repartitioned? Snapshot Delta merge Savepoint Reorganization.
What happens when you rename a tenant in an SAP HANA database?
Note: There are 2 correct answers to this question. The database is renamed The directories are renamed The logs are renamed The backups are renamed.
You migrate an SAP HANA system using the SUM database migration option.
Which activities do you perform to activate the viewer mode for SAP support?
Note: There are 2 correct answers to this question. Create the database user <sid>obs on the application server Create the OS user <sid>obs on the application server Provide the SUM observer URL to SAP support Provide the SUM URL to SAP support.
You need to recover a tenant database backup from SAP HANA system 1 into SAP HANA system 2.
Which activities do you perform to restore the tenant?
Note: There are 2 correct answers to this question. Create the tenant in the target database Start the recovered tenant database Recover the tenant with initialize log area option Copy the transaction logs to the target database.
Which kinds of patches are available in the SAP HANA revision strategy?
Note: There are 2 correct answers to this question. Support Package Datacenter Service Point Support Package Stack Feature Package Stack.
You need to rename a tenant database using the manage databases app in the SAP HANA cockpit.
Which prerequisities do you require?
Note: There are 2 correct answers to this question. The Tenant database must be on one host The tenant database is stopped The System Database must be on the master node You have the DATABASE ADMIN system privileges.
Wich SUM database migration option utility do you use to check and monitor table splitting? R3ta Log tail viewer Table comparison R3load utilization.
How can ensure that critical database system properties CANNOT be changed by tenant database administrators? Set up cross-database access control Edit the configuration change blacklist Set database isolation levels to high Assign internal communication ports.
The recovery of your productive SAP HANA database fails log replay.
What is the fastest solution to complete the recovery Resume the interrupted recovery Restart the database and resume the interrupted recovery Repeat the recovery from the beginning Replay the delta backups and logs backups.
How do you trigger a savepoint in an SAP HANA database? Start a log backup Perform a soft shutdown commit a transaction Execute a delta merge.