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