What do you do to prepare the database migration option of a Software Update Manager procedure? Note: There are 3 correct answers.
- A . Move the SPAM update archive into the download folder
- B . Extract the SAP HANA Client installation archive
- C . Move the stack.xml update file into the download folder
- D . Extract the SAP HANA database installation archive
- E . Move the R3trans update archive into the download folder
Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to
- A . Keep all partitions on different hosts.
- B . Keep the number of partitions per table high.
- C . Keep the number of partitioned tables low.
- D . Keep the number of key columns low.
Which tools are integrated into the SAP HANA cockpit? There are 3 correct answers to this question.
- A . Database Explorer
- B . HANA Sitter
- C . SQL Console
- D . SQL Analyzer
- E . HDB Admin
How are save points triggered? There are 2 correct answers to this question
- A . By a database soft shutdown.
- B . By issuing a transactional commit.
- C . By performing a delta merge.
- D . By performing a database backup.
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
Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer.
- A . DATABASE ADMIN
- B . WORKLOAD ADMIN
- C . INIFILE ADMIN
- D . RESOURCEADMIN
At the end of the SAP HANA Cockpit 2.0 installations, how can you obtain the URL of the SAP HANA cockpit and the SAP HANA cockpit manager?
- A . Installation log file
- B . COCKPIT_ADMIN user logs
- C . Installation logs screen
- D . Installation config screen
In which circumstances do you create a column store table? There are 3 correct answers to this question.
- A . When the calculations are based on a small number of columns
- B . When aggregations or fast search is required
- C . When accessing complete records
- D . When the table has a large number of columns
Which actions are always recorded when auditing is active? Note: There are 2 correct answers.
- A . Disable auditing
- B . Grant or revoke user
- C . Modification of an audit policy
- D . Create or drop user
For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.
- A . Business Suite on HANA
- B . SAP HANA Live for SAP Business Suite
- C . SAP S/4HANA
- D . Web-based native applications based on XS
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
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 2TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.
- A . 1TB
- B . 0.5 TB
- C . 3 TB
- D . 1.5 TB
Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.
- A . Only one user group per user group operator
- B . Only one user group operator per user group
- C . Multiple user groups per user group operator
- D . Multiple user group operators per user group
Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this questions.
- A . DRAM required for the static data memory area
- B . Persistent memory (PMEM) required for backups
- C . Total disk space required for the log volume
- D . Network bandwidth for the storage zone
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? There are 2 correct answers to this question.
- A . The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
- B . The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.
- C . The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
- D . The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
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.
- A . When the alert checker identifies an issue
- B . When the alert checker identifies a resolved issue
- C . When the alert checker is turned off
- D . When the alert checker identifies a recurring issue
Which system privilege must you have to redistribute tables across the hosts in your scale-out system?
- A . OPTIMIZER ADMIN
- B . DATA ADMIN
- C . WORKLOAD ADMIN
- D . RESOURCE ADMIN
What can you assign to a user with the User Management app in SAP HANA cockpit? There are 2 correct answers to this question.
- A . LDAP identity provider
- B . Scopes
- C . User group
- D . LDAP authorization mode
What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question.
- A . Having the data and log volumes on the different disks.
- B . Obtaining the hardware certification from SAP for the existing hardware you are going to use.
- C . Obtaining C_HANATEC_XX Certification.
- D . Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.
In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?
- A . Indexserve.ini
- B . Nameserver.ini
- C . Multidb.ini
- D . Sapprofile.ini
What can you do to shorten the startup time of an SAP HANA system after a reboot?
- A . Flag all columnar tables for preload.
- B . Set the savepoint interval to a lower value.
- C . Set the preload column value in the Tables system table to FULL.
- D . Partition the row store across nodes.
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 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
You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and user management .
Which deployment scenario do you use?
- A . Multiple Components on One Database (MCOD)
- B . Multitenant database containers (MDC)
- C . Technical co-deployment (TCD)
- D . Multiple Components on One System (MCOS)
Which information is provided via the SUM UI? There are 3 correct answers to this question.
- A . The content of log files via the log viewer
- B . The memory consumption of SUM
- C . A progress bar for the overall procedure
- D . The active roadmap step
Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correct answers to this question.
- A . Delta Backup
- B . Backup of Configuration files
- C . Data Backup
- D . Data Snapshot
How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?
- A . Set up cross-database access control
- B . Set database isolation levels to high
- C . Edit the configuration change blacklist
- D . Assign internal communication ports
You install a productive multi-host system with failover capabilities .
Which storage condition prerequisites must be ensured? Note: There are 2 correct answers.
- A . The standby host has file access
- B . The standby host has NO file access
- C . The failed worker host has access to write files
- D . The failed worker host no lonqer has access to write to files
You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers .
Which rules apply? There are 2 correct answers to this question.
- A . The system database must run on the standby host.
- B . The system database instance must run on all hosts (worker and standby).
- C . The tenant databases must be able to be scaled out to all hosts (worker and standby).
- D . The tenant databases must run on the worker hosts.
Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system? Note: There are 2 correct answers.
- A . Topology data on the location of tables and table partitions
- B . Monitoring data in the SYSTEMDB and all tenant databases
- C . Users and authorizations of the SYSTEMDB and all tenant databases
- D . Landscape topology data on the system as a whole
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.
- A . The R3LDCTL
- B . The Process Bucket monitor
- C . The Log viewer
- D . The Observer Monitor
What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question.
- A . Critical
- B . Auto
- C . Hard
- D . Smart
Which role do you need in order to assign users to groups in the SAP HANA cockpit? Please choose the correct answer.
- A . Cockpit User Role
- B . Cockpit Administrator Role
- C . Cockpit User Administrator Role
- D . Cockpit Database Administrator Role
Which target database does the SUM databases migration option provide by default? Note: There are 2 correct answers.
- A . SAp MaxDB
- B . SAP ASE
- C . SAP IQ
- D . SAP HANA
What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.
- A . For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4
- B . For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2
- C . For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10
- D . For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15
Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start? Please choose the correct answer.
- A . hdbcons
- B . RecoverStateCheckerpy
- C . sap control
- D . HDBAdmin
What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer.
- A . SAP HANA XS Advanced
- B . SAP NetWeaver Application Server Java
- C . SAP Fiori launchpad
- D . SAP NetWeaver Application Server ABAP
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
Which connections do you need to enable explicitly for a Restricted user? There are 2 correct answers to this question.
- A . ODBC
- B . JDBC
- C . OLEDB
- D . ADO.NET
SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question.
- A . Create a restricted user
- B . Assign a user to a user group
- C . Create and delete users
- D . Lock and unlock users
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?
- A . hdbuserstore
- B . xuser
- C . Secure store in file system (SSFS)
- D . ABAP secure store file system (SSFS)
In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.
- A . Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA
- B . Consolidating multiple ERP source systems into one ERP system on SAP HANA
- C . Carving out ERP functionality from the source system to the ERP on SAP HANA system.
- D . Customers are new to SAP applications and SAP HANA
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.
- A . basepathjogmirror
- B . basespath_export
- C . basepathjogbackup
- D . basepath_databackup
When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question.
- A . When you need to extend the scale-out memory
- B . When you need to optimize the standby node memory.
- C . When you need to measure total memory
- D . When you need to actively free up memory.
Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question.
- A . <sid>crypt
- B . sap<sid>
- C . Idapadm
- D . sapadm
Why do we still need a persistent layer? There are 2 correct answers to this question.
- A . To store data that has been unloaded from memory
- B . To enable full database recovery if we have a power failure
- C . To hold the delta store for newly arrived records
- D . To store data that is frequently used
Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question
- A . Preprocessor
- B . XS Engine
- C . Index server
- D . Compile server
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
How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.
- A . Provide the measured table migration duration data for optimal table sequencing during benchmarking.
- B . Set the optimal number of R31oad processes during benchmarking and the DMO procedure
- C . Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.
- D . Use the benchmarking option to find the optimal throughput during the DMO procedure.
A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.
- A . recover the system database and the affected tenant with the initialize log area option
- B . restore the database and recover the affected tenant upto moment of the problem
- C . recover the affected tenant upto moment of the problem
- D . recover the affected tenant with the initialize log area option
Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.
- A . To persist in-memory data
- B . To ensure maximum performance
- C . To enable database scale-up
- D . To allow a restart if the power fails
In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.
- A . When the log buffer is full.
- B . When the time threshold is exceeded.
- C . When the log segment is full.
- D . When a commit occurs.
Which of the following tools can be used for User Administration? There are 3 correct Answers to this question.
- A . SAP NetWeaver Identity Management
- B . hdbsql
- C . Resident hdblcm
- D . SAP HANA Cockpit
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
Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer.
- A . On the Additional Application Server (AAS) host
- B . On the source and target host
- C . On the remote target database host
- D . On the Primary Application Server (PAS) host
You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration .
Which steps take place during downtime? 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 EU_CLONE_MIG_DT_RUN
- D . Creation of application tables in the target database in phase EU_CLONE_MIG_DT_CREATE
To ensures that the database can be restored to the most recent committed state after a restart which of the following Index server components make sure such consistency and maintain durable changes?
- A . Storage Engine
- B . Disk Storage
- C . Relational Engines
- D . Request Processing
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
You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database.
From which location does the Recover Database app read the recovery information by default?
- A . $(DIR_INSTANCE)/<hostname>/trace
- B . $(DIR_INSTANCE)/backup/data
- C . $(DIR_INSTANCE)/../global/hdb/custom/config
- D . $(DIR_INSTANCE)/backup/log
Which products do you use for SAP HANA administration? There are 2 correct answers to this question.
- A . SAP Solution Manager
- B . SAP Web IDE for SAP HANA
- C . SAP HANA cockpit
- D . SAP Master Data Governance
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 SUM database migration option utility do you use to check and monitor table splitting?
- A . R3ta
- B . Log tail Viewer
- C . Table comparison
- D . R3load utilization
You suspect an authorization issue while executing SAP HANA reports that contain calculation views .
How do you configure the authorization trace? There are 2 correct answers to this question.
- A . Specify the name of the table/view.
- B . Select INFO from the System Trace Level for the Index server component and then select AUTHORIZATION.
- C . Specify the user as the database user.
- D . Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.
Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit? There are 3 correct answers to this question.
- A . Cockpit User
- B . Database User
- C . sap
- D . <sid>adm
- E . Root
What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose
- A . Metadata Manager and Transaction Manager
- B . Page Management and logge
- C . Column Store and Row Store
- D . Session Management and log Volumes
What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer.
- A . Back up tenant database
- B . Copy tenant database.
- C . Start tenant database.
- D . Restart secondary system.
Which operating system process takes care of starting the SAP HANA database system services?
Please choose the correct answer.
- A . hdbrsutil
- B . hdbdaemon
- C . apstartsrv
- D . sapstart
When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question.
- A . The SAP ABAP kernel on the application server
- B . The DBACOCKPIT user on the SAP HANA database
- C . The updated BRTOOLS on the non-SAP database
- D . The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database
- E . The shadow schema on the non-SAP database
In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function? There are 2 correct answers to this question.
- A . The input parameter must be set to mandatory.
- B . The function can return multiple values.
- C . The function must be of the type scalar.
- D . The generated value can be overwritten at runtime.
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.
What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.
- A . >= 6TB
- B . >= 8TB
- C . >= 8cpu
- D . >= 12cpu
Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.
- A . The SYSTEM user of the tenant database
- B . The user who created the role
- C . The _SYS_REPO technical user
- D . The container-specific technical user
Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor? There are 3 correct answers to this question.
- A . Memory and CPU consumption from the SAP HANA database.
- B . Disk consumption from the SAP HANA database.
- C . Connection statistics about open connections.
- D . The time at which the database was started.
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.
- A . threshold_cpu_time
- B . cpu_time_measurement_mode
- C . load_monitor_granularity
- D . enable_tracking
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? Please choose the correct answer.
- A . A restart of the primary system
- B . A restart of the secondary system
- C . An upgrade of the secondary system
- D . An upgrade of the primary system
What cryptographic libraries are supported in SAP HANA by default? There are 2 correct answers to this question.
- A . LibgCrypt
- B . OpenSSL
- C . Common Cryptolib
- D . WolfCrypt
How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.
- A . Use the Test Cycle option to determine the optimal number of R3load processes.
- B . Use the UPGANA.XML analysis file to optimize the number of R3load processes.
- C . Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence.
- D . Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables.
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 SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.
- A . Admission control
- B . Capture and replay
- C . Thread throttling
- D . Workload classes
What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.
- A . OS/DB certified consultant
- B . Migration check Services
- C . Migration key
- D . Stack.xml file