Reloading column tables in this way restores the database to a fully operational state more quickly.
However, it does create performance overhead, and may not be necessary in nonproductive systems, how can you deactivate the the reload feature? Please choose the correct answer.
- A . Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true
- B . Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false
- C . Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false
- D . Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false
Which of the following are characteristics of SAP HANA Smart Data Streaming? Please choose the correct answer.
- A . It uses databases queries.
- B . It is a standalone product for use with any target system.
- C . It acts based on combinations of events.
- D . It provides reports and analysis on the received data.
Which of the following recovery types is not supported for delta backups? Choose the correct answer.
- A . Recover the database to its most recent state.
- B . Recover the database to a specific point in time.
- C . Recover the database to a specific data backup.
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? Please choose the correct answer.
- A . $(DIR_INSTANCE)/../global/hdb/custom/config
- B . $(DIR_INSTANCE)/backup/log
- C . $(DIR_INSTANCE)/<hostname>/trace
- D . $(DIR_INSTANCE)/backup/data
Which combination of source and target systems is allowed when you perform a database copy in a scale-out scenario? Please choose the correct answer
- A . The source system can have 4 hosts.
The target system can have 2 hosts. - B . The source system can have 4 index servers.
The target system can have 2 index servers. - C . The source system can have 2 hosts.
The target system can have 4 hosts. - D . The source system can have 2 index servers.
The target system can have 4 index servers.
How many tiers do you usually find in an SAP HANA application? There are 2 correct answers to this question.
- A . 1
- B . 2
- C . 3
- D . 4
Which of the following actions triggers the replication of SAP BW authorizations in SAP HANA? There are 3 correct answers to this question.
- A . System restart
- B . InfoProvider activation
- C . Execution of "Replicate BW user authorizations to HANA database" process chain
- D . Execution of report "RS2HANA_AUTH_RUN"
Which tool do you use to create a new tenant when you install SAP HANA multitenant database containers? Please choose the correct answer.
- A . Manage Databases app of SAP HANA cockpit 2.0
- B . Administration Console of the SAP HANA studio
- C . HDBSQL command line and the CREATE SCHEMA statement
- D . System Configuration tab of the DBA Cockpit
You implement a multi-host SAP HANA system with auto-failover capabilities.
What are the requirements for the disk storage? There are 2 correct answers to this question.
- A . The slave node is set to backup standby.
- B . The failed worker host gets fenced during failover.
- C . The standby host has file access.
- D . The master node is fully clustered.
Which R3load mode is used during a database migration option procedure? Please choose the correct answer.
- A . Pipe
- B . File
- C . Network
- D . Socket
For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.
- A . SAP HANA Live for SAP Business Suite
- B . Business Suite on HANA
- C . SAP S/4HANA
- D . Web-based native applications based on XS
What happens when an SAP HANA system is restarted? There are 2 correct answers to this question
- A . The list of open transactions is left open.
- B . All row tables are loaded into the memory except the row tables that are configured to be loaded on demand.
- C . All row tables and row table attributes are loaded into the memory.
- D . The Redo log is replayed from the last savepoint.
In the Aggregate Health Monitor application, you are viewing the overall status of all tenants assigned to your SAP HANA cockpit user.
Which user retrieves this database status information? Please choose the correct answer.
- A . A named user with monitor permissions
- B . The system user
- C . The cockpit_admin user
- D . A technical user with limited permissions
You need to check the new monitoring option in SAP HANA cockpit 2.0.
Which SAP HANA cockpit 2.0 app do you use? Please choose the correct answer.
- A . Monitor Performance
- B . Configure Alerts
- C . Manage Database Backups
- D . Configure System Properties
You define the parameters for password policy of an SAP HANA tenant database where the parameters are stored? Please choose the correct answer.
- A . indexserver.ini
- B . multidb.ini
- C . nameserver.ini
- D . global.ini
You create a new user by copying an existing user.
Which predelivered role of the existing user is automatically granted to the new user?
- A . Modeling
- B . Runtime
- C . Monitoring
- D . Repository
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? Please choose the correct answer.
- A . Multitenant database containers (MDC)
- B . Technical co-deployment (TCD)
- C . Multiple Components on One Database (MCOD)
- D . Multiple Components on One System (MCOS)
The administration console is pre-delivered by SAP. You can access the administration console in one of the following ways. There are 3 correct answers to this question.
- A . Choose the Administration button in the upper left corner
- B . Choose the Administration button in the upper right corner
- C . Double-click the system in the system monitor
- D . Double-click the system monitor in the Navigator view
- E . Double-click the system in the Navigator view
Which of the following tasks requires the BACKUP ADMIN authorization? There are 2 correct answers to this question.
- A . Backing up the database without a user interface.
- B . Recovering the database without a user interface
- C . Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location.
- D . Administration tasks executed on a tenant database through the system database.
Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.
- A . The target database must have a the same or higher version than the source database.
- B . You don’t have to be concerned about disk space and memory of the target database.
- C . Source and target databases can have different number and types of services.
- D . A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available.
Which of the following statements are true about SAP HANA Live? There are 2 correct answers to this question.
- A . SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite.
- B . SAP HANA Live for SAP Business Suite is an accelerator.
- C . SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases.
and not on live operational reporting. - D . SAP HANA Live for SAP Business Suite comprises of an Analytical Model.
- E . SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution.
Which of the following statements are true regarding In-Memory computing security? There are 2 correct answers to this question.
- A . Data and undo log information (part of data) are automatically saved to disk at regular savepoints
- B . The log is also saved to disk continuously and synchronously after each COMMIT of a database transaction
- C . The redo log captures last 5 minutes changes by database transactions
- D . After a power failure the system returns to its last consistent state by replaying the undo log since the last savepoint
How can you minimize the database migration option (DMO) downtime? Please choose the correct answer.
- A . Adjust the number of R3load processes during benchmarking and the DMO procedure.
- 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 . Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes.
Why might you want to reference a user-provided service in a project? Please choose the correct answer.
- A . To access data from another container
- B . To access data from a classic database schema
- C . To access data from your project container
You migrate a database using the database migration option.
Which tools are available to monitor the migration? There are 2 correct answers to this question.
- A . Process Bucket monitor
- B . Log Tail Viewer monitor
- C . Table Depooling monitor
- D . Table Splitting monitor
You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one server. This system will be your customer’s 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 instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
- C . The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.
- D . The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
How to open Web user interface for HDBLCM from SAP HANA Studio from the context menu? Please choose the correct answer.
- A . HDBLCM ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle
Management - B . HDBLCM ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle
Management - C . Lifecycle ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle
Management - D . Lifecycle ManagementPlatform Lifecycle ManagementOpen HDBLCM
USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards.
What happens if you drop USER B from the HANA database? Choose the correct answer.
- A . The privilege is revoked from both USER A and USER C.
- B . The privilege is revoked from USER C, but not USER A.
- C . The privilege remains assigned to both USER A and USER C.
- D . The privilege is revoked from USER A, but not USER C.
Which activities are required when you execute an SAP HANA Near Zero Downtime upgrade? There are 2 correct answers to this question.
- A . Perform a takeover3.
- B . Upgrade the secondary system with the command line tool.
- C . Stop the secondary system.
- D . Restart the primary and secondary system.
What are the advantages of the DMO procedure? There are 3 correct answers to this question.
- A . DMO combines several steps into one procedure.
- B . DMO allows a lower target release on SAP HANA database.
- C . DMO allows an easy reset during the procedure.
- D . DMO is an inplace procedure by default, keeping the application server host.
Which partitioning type must you use to produce an equal distribution of rows in the SAP HANA database? Please choose the correct answer
- A . Round-robin
- B . Aging
- C . Hash-range
- D . Range
From an architectural standpoint, which of the following components belong to the SAP HANA Indexserver? There are 2 correct answers to this question.
- A . External Interfaces
- B . Preprocessor
- C . Relational Engines
- D . SAP Web Dispatcher
You need to test an ABAP report, which uses SAP HANA objects, in the quality assurance (QA) system.
Which tool do you use to import all objects to the QA system? Please choose the correct answer.
- A . SAP HANA Application Lifecycle Manager
- B . SAP HANA Quality Gate Maintenance
- C . SAP HANA Change Request Management
- D . SAP HANA Transport Containers
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?
- A . The latest log backup
- B . The latest incremental backup
- C . The last commited transaction
- D . The last full data backup
which action do you perform when SAP HANA Database is running out of space Please choose the correct answer.
- A . Create a new tenant database
- B . extend the file system size on the operating system level
- C . create a new databse volume
- D . extend the size of database volume
You are using USER01 and modelling a calculation view that combines existing calculation views with tables belonging to SCHEMA02. You want to activate the new calculation view, but you get a User is NOT Authorized error.
What is the cause of the error? Please choose the correct answer.
- A . User _SYS_REPO is missing object privileges for SCHEMA02.
- B . The calculation view was created in the sap package.
- C . USER01 is missing object privileges for SCHEMA02.
- D . The calculation view was created in the system-local package.
You are applying SAP Support Packages during an SUM DMO run to SAP HAN
Which options are possible to select in the main dialog Tool Configuration? There are 3 correct answers to this question.
- A . Single System
- B . Standard
- C . Advanced
- D . Expert Mode
Which of the following options are valid SAP HANA backup strategies? There are 2 correct answers to this question
- A . A storage snapshot followed by incremental backups and differential backups
- B . An offline backup followed by incremental backups and differential backups
- C . A full data backup followed by incremental backups and differential backups
- D . A data snapshot followed by incremental backups and differential backups
You imported the following objects.
Which of them always require an activity from you before they can be built? There are 2 correct answers to this question.
- A . Synonyms definition
- B . Multi-target application
- C . Logical schema definition
- D . SAP HANA database module
You need to secure client-server communication using transport layer security.
Which objects must you set up on the server side? There are 2 correct answers to this question.
- A . User certificate
- B . Private key
- C . Root certificate
- D . Server certificate
Which of the following traces has the default configuration status of “Active”? Choose the correct answer.
- A . Performance trace
- B . Database trace
- C . SQL trace
- D . Kernel profiler
Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.
- A . Set the password for the system database user.
- B . Trigger the conversion in the SAP HANA cockpit 2.0.
- C . Generate the system database before the conversion.
- D . Create an operating system user for the converted tenant database.
Who can access the runtime object generated from a repository object immediately after the activation? Please choose the correct answer.
- A . The user who started the activation
- B . The SYSTEM user
- C . The _SYS_REPO user
- D . The user who created the repository object
What do you have to ensure during the downtime phases of SUM? There are 3 correct answers to this question.
- A . The source database must be stopped
- B . End users can not log on to the SAP system
- C . Batch jobs from daily business can not start
- D . Interfaces from other SAP systems can not log on to the SAP system
Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.
- A . Hash
- B . Composite
- C . Round-robin
- D . Cluster
- E . Range
Which productive deployment option is valid when you combine SAP ERP and SAP SCM in one SAP HANA system? Please choose the correct answer.
- A . SAP HANA AppServices
- B . Multitenant database containers
- C . Technical co-deployment
- D . SAP HANA One
What is XS? Choose the correct answer.
- A . A native, lightweight application server
- B . An optional engine to handle excessive data loads
- C . A data cleansing engine
- D . A user interface
Your customer wants to know when the productive SAP HANA system was updated and to which version.
Where do you find this information? There are 2 correct answers to this question
- A . In the General Information app of SAP HANA cockpit 2.0
- B . In the administration editor of the SAP HANA studio
- C . In the catalog view of the SAP HANA Web-based Development Workbench
- D . In the SAP HANA database explorer for SAP HANA cockpit 2.0
What is XS? Choose the correct answer.
- A . A native, lightweight application server
- B . An optional engine to handle excessive data loads
- C . A data cleansing engine
- D . A user interface
Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values? Choose the correct answer.
- A . System Privileges
- B . Object Privileges
- C . Analytic Privileges
- D . Package Privileges
Which security settings can you monitor in SAP HANA cockpit 2.0? There are 2 correct answers to this question.
- A . Data Storage Security
- B . Password Policy
- C . Manage Database Backups
- D . Manage Users
Which of the following elements are SAP HANA system components There are 2 correct answers to this question.
- A . SAP HANA Database
- B . SAP HANA Dynamic Tiering
- C . SAP HANA Advanced Data Processing
- D . SAP HANA Remote Data Sync
What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.
- A . Data preparation functions
- B . Text mining functions
- C . Predictive algorithms
- D . Flowgraphs
In the context of the SAP HANA maintenance strategy, which of the following terms is connected to bundle new features and functions to the SAP HANA Platform? Choose the correct answer.
- A . SAP HANA standard revisions
- B . SAP HANA maintenance revisions
- C . Support package stack (SPS)
- D . Support packages (SP)
Which connection type can a standard restricted user use to connect to the SAP HANA database? Please choose the correct answer.
- A . ODBC
- B . TCP/IP
- C . JDBC
- D . HTTP(S)
Where can you check the trace and log files when your SAP HANA database is NOT available? Please choose the correct answer.
- A . In the Trace app of the SAP HANA Web-based Development Workbench
- B . in the $DIR_INSTANCE/exe/python_support directory
- C . in the troubleshoot of unresponsive system app of HANA cockpit 2.0
- D . in the troubleshoot of unresponsive system app of hana cockpit for offline administration
In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role? Please choose the correct answer.
- A . Sapprofile.ini
- B . Indexserve.ini
- C . Nameserver.ini
- D . Multidb.ini
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 . The time at which the database was started.
- B . Disk consumption from the SAP HANA database.
- C . Connection statistics about open connections.
- D . Memory and CPU consumption from the SAP HANA database.
Your SAP HANA database is running in log mode “normal” and automatic log backups “enabled”.
With this configuration, In which situations are the log segments backed up automatically? There are 3 correct answers to this question.
- A . The log segment is full.
- B . The database is started.
- C . The log segment is closed after exceeding the configured time threshold.
- D . The database is stopped.
In SAP HANA Studio, what would you find in a Package? There are 3 correct answers to this question.
- A . Calculation Views
- B . Analytic Privileges
- C . Procedures
- D . Tables
Which backup scenarios are allowed in multitenant database containers? There are 2 correct answers to this question.
- A . A backup of a tenant database can be recovered to an SAP HANA single-container system.
- B . A tenant database can initiate its own backup unless this is prohibited by the system configuration.
- C . A tenant database can initiate its own backup and the backup of the other tenant databases.
- D . The system database can initiate its own backup and the backup of tenant databases.
Which encryption service can you activate in HANA There are 3 correct answers to this question.
- A . Pages-in memory
- B . Data
- C . storage snapshot
- D . backup
- E . log
SAP HANA uses SSFS to protect the root encryption keys. These root keys protect all encryption keys used in the SAP HANA database from unauthorized access.
What other two main functions of the root encryption keys? There are 2 correct answers to this question.
- A . The root key used for the internal data encryption service of the database
- B . The root key used for data volume encryption
- C . The root key used for users log encryption
- D . The root key used for transactions volume encryption
What is a prerequisite for a system replication when the development (DEV) system and the quality (QA) system are installed on the secondary site? Please choose the correct answer.
- A . The DEV and QA systems must be online during system takeover.
- B . The preload of tables must be switched off.
- C . The global allocation limit must be identical.
- D . The SIDs and instance numbers must be identical.
In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs).
However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions? There are 2 correct answers to this question.
- A . The standby host has file access
- B . SYSTEM users replaced by standby host
- C . The failed worker host no longer has access to write to files
- D . The standby host has access to write to files
Which of the following elements are valid rules for the location of the backup files? There are 3 correct answers to this question.
- A . The Volume ID is automatically added to a specified file name.
- B . The backup files should never be in the same directory and on the same file system as the data.
- C . The backup ID is unique for each persistence only.
- D . The backup folder will be created automatically when the backup process is started.
Which identity provider is used by default by SAP HANA extended application services, advanced model (XS Advanced)? Please choose the correct answer.
- A . SAP HANA user store
- B . SAP Identity Management
- C . SAP ID service
- D . SAP Cloud Identity
Which of the following tools can be used for User Administration? There are 3 correct answers to this question.
- A . SAP HANA Cockpit
- B . hdbsql
- C . Resident hdblcm
- D . SAP NetWeaver Identity Management
Which of the following authentication methods are available in SAP HANA? Please select all the correct answers that apply.
- A . Login with user and password
- B . Use of SAML identity provider assertion tickets
- C . Reuse the Kerberos ticket issued by the Active Directory
- D . Use the SAP Logon ticket issued by another SAP ABAP system
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 and delete users
- B . Lock and unlock users
- C . Assign a user to a user group
- D . Create a restricted user
In the General Licensing Process which of the following statements are true regarding Temporary license keys? There are 2 correct answers to this question.
- A . Temporary license keys are manually installed by the SAP HANA system
- B . Temporary license keys are automatically installed by the SAP HANA system
- C . After 90 days, the temporary license expires and the system is locked down
- D . After 28 days, the temporary license expires and the system is locked down
What is a characteristic of the synchronous in-memory system replication mode in SAP HANA? Please choose the correct answer.
- A . The primary systems suspends transaction processing until the connection to the secondary system is re-established.
- B . The primary system waits until the secondary system confirms the log was persisted.
- C . The primary system does NOT wait for the confirmation of the secondary system.
- D . The primary system waits until the secondary system confirms receiving the log.
Which of the following statement is not true regarding SAP HANA Server Components? Please choose the correct answer.
- A . The index server contains the actual data stores and the engines for processing the data
- B . Index server is access by SAP HANA Cockpit with SQL queries
- C . Web based tools can access the index server with simple HTTP request
- D . XS Engine process the client application with HTTP request
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 answer
- A . Recover the system database. The affected tenant is recovered automatically.
- B . Recover the system database first and then recover the affected tenant.
- C . Recover the affected tenant. The system database is NOT recovered.
- D . Recover the affected tenant first and then recover the system database.
You plan to implement SAP HANA multitenant database containers using a scale-out scenario with high availability.
What rules can be applied when you implement such an SAP HANA system? Note: There are 2 correct answers to this question.
- A . Single tenant databases can be failed over to the standby host.
- B . Tenant databases can be automatically distributed across all the available hosts.
- C . An instance of the system database can run on all the nodes, including the standby host.
- D . An instance of the system database can run on all the nodes, except the standby host.
You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user.
Which tools can you use to execute an SQL query? There are 2 correct answers to this question.
- A . SQL Command Editor of the DBA Cockpit on the application server
- B . SAP HANA studio on the SAP HANA server
- C . HDBSQL command line tool on the SAP HANA server
- D . SAP HANA cockpit 2.0 on a central server
What are the prerequisites for configuring audit logging? There are 2 correct answers to this question.
- A . AUDIT ADMIN system privilege
- B . INIFILE ADMIN system privilege
- C . AUDIT OPERATOR system privilege
- D . INIFILE OPERATOR system privilege
Which security infrastructures can you integrate with SAP HANA? There are 2 correct answers to this question.
- A . Linux syslog
- B . Radius server
- C . Identity management
- D . Intrusion detection
A developer at your customer starts a badly designed query.
How do you stop this query? Please choose the correct answer.
- A . Use the Threads app to cancel the thread.
- B . Use the Monitor Statements app to interrupt the statement.
- C . Use the Expensive Statements Trace app to stop the statement.
- D . Use the Sessions app to end the session.
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.