Which types of backups can you use to copy an SAP HANA tenant database?
There are 2 correct answers to this question. Full database backup Fallback snapshot Data snapshot.
What are the advantages of column store tables?
There are 3 correct answers to this question.
They are optimized for high-volume read /write transactional processing Columns can be partitioned Only the columns required are actually loaded to memory Data footprint is automatically reduced through compression.
Which table holds the data used for the dynamic management of partitions and locations?
Please choose the correct answer.
EFFECTIVE_TABLE_PLACEMENT TABLE_GROUP TABLE_PLACEMENT UPDATE_ LANDSCAPE_CONFIGURATION.
Which tools can you use to monitor the response time of individual SQL queries?
There are 2 correct answers to this question.
SQL plan cache Statement Monitor Thread Monitor SQL Trace.
What are the supported operating systems for SAP HANA on IBM Power Servers?
There are 2 correct answers to this question.
For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP2 For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15 For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.3 and 8.x For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 7.2.
Which of the following actions are possible when managing roles?
There are 3 correct answers to this question.
A role can be nested to multiple other roles A role can contain multiple other roles A role can contain other roles and privileges at the same time A role can contain either other roles or privileges but not both together.
Which partitioning option distributes rows equally for load balancing in the SAP HANA database?
Please choose the correct answer.
Hash Range Range-Range RoundRobin.
You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system?
Please choose the correct answer.
Syncing Unknown Error Initializing.
Which file systems are supported for the SAP HANA database system?
There are 2 correct answers to this question.
MPFS EXT3 Dxfs GPFS.
In a Multiple Database Container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases?
Please choose the correct answer.
DATABASE ADMIN BACKUP ADMIN BACKUP OPERATOR TENANT ADMIN.
Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL?
There are 2 correct answers to this question.
HDBAdmin hdbcons Sapcontrol HANASitter.
Which prerequisites must be fulfilled to rename a tenant database in the SAP HANA cockpit?
There are 2 correct answers to this question.
The tenant database is not part of a move operation. The on-disk tenant directory should be a mount point. The tenant database is stopped. The tenant database must be unloaded from memory.
You need to recover a tenant database backup from SAP HANA system 1 into SAP HANAsystem2. Which activities do you perform to restore the tenant?
There are 2 correct answers to this question.
Create the tenant in the target database tart the recovered tenant database Copy the transaction logs to the target database Recover the tenant with the Initialize Log Area option.
You want to implement a 28-day backup cycle. Which scenario uses the least storage?
Please choose the correct answer.
Full backup, incremental backup, log backup Incremental backup, log backup Full backup, differential backup, log backup Full backup, log backup.
Which tasks must you perform to convert a single database to a multitenant database system?
There are 2 correct answers to this question.
Create an operating system user for the converted tenant database. Set the password for the system database user. Trigger the conversion in the SAP HANA cockpit 2.0. Generate the system database before the conversion.
Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings?
There are 2 correct answers to this question. /hana/shared /usr/sap <SID> /hana/log/<SID> /usr/sap/hostctrl.
Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface?
There are 2 correct answers to this question.
SAP HANA Client software locally installed. Communication port 1129 is open. Installed SAP Host Agent on the SAP HANA host. SAP HANA database system in any version.
Which of the following tools can be used for User Administration?
There are 3 correct answers to this question.
SAP NetWeaver Identity Management Resident hdblcm SAP HANA Cockpit hdbsql.
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.
The DBACOCKPIT user on the SAP HANA database The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database The updated BRTOOLS on the non-SAP database The shadow schema on the non-SAP database The SAP ABAP kernel on the application server.
You want to perform the database migration option (DMO) procedure. Which components have to be updated if they are not on the right version level?
There are 2 correct answers to this question.
ASAP Kernel SAP Host Agent ST-Pl SPAM/SAINT.
Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks?
Please choose the correct answer.
_SYS_STATISTICS _SYS_WORKLOAD_REPLAY _SYS_SQL_ANALYZER _SYS_TELEMETRY.
What is the first node limit for planning an SAP S/4HANA scale-out system?
There are 2 correct answers to this question.
>= 12CPU >= 6TB >= 8TB >= 8CPU.
Which actions take place during a database migration option (DMO) procedure when performing an in-place migration?
There are 2 correct answers to this question.
De-pooling of tables is done during the procedure. TABART is considered for the creation of R3load control files. SAP up decides which tables to split. One table is migrated per R3load pair.
Which prerequisites must be fulfilled before adding hosts to an SAP HANA scale-out system?
There are 2 correct answers to this question.
The SAP HANA system installation is on a shared file system. The host has access to the installation directories. The SAP HANA database server is shut down. The additional host is placed in a different data center.
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.
hdbcons RecoverStateChecker.py sap control HDBAdmin.
Which prerequisites are necessary for productively using SAP HANA cockpit 2.0?
There are 2 correct answers to this question.
An Intel-based system with operating system Microsoft Windows 16 GB RAM on a dedicated server An IBM Power System with operating system SUSE Linux Enterprise Server (SLES) 10 GBit/s network bandwidth.
Which file systems are supported for the data and log volumes of the SAP HANA 2.0 database system?
There are 2 correct answers to this question.
GPFS OCFS2 Btrfs XFS.
What is the additional disk space factor required during delta merge operations?
Please choose the correct answer.
1.2 3.0 1.6 4.0.
For an SAP HANA tailored data center integration (TDI) approach, what is the additional disk space factor required during delta merge operations?
Please choose the correct answer.
3.0 1.6 1.2 2.0.
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?
Please choose the correct answer.
Kernel profiler End-to-End User-Specific SQL.
Which prerequisites must be fulfilled when recovering a tenant database?
There are 2 correct answers to this question.
You need the logon credentials of the <sid> adm user. You need the logon credentials of the system database user. The whole system is shut down, including all tenant databases. Before the recovery starts, the tenant database must be stopped.
Which actions are always recorded when auditing is active?
There are 2 correct answers to this question.
Grant or revoke user Disable auditing Create or drop user Modification of an audit policy.
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.
In the administration editor of the SAP HANA studio In the General Information app of SAP HANA cockpit 2.0 In the catalog view of the SAP HANA Web-based Development Workbench In the SAP HANA database explorer for SAP HANA cockpit 2.0.
Which prerequisites must you consider to rename a tenant database in the SAP HANA cockpit?
There are 2 correct answers to this question.
The tenant database must be unloaded from memory. The database that is not in move operation. The on-disk tenant directory should be a mount point. The tenant database is stopped.
Which certificates can you manage in SAP HANA cockpit 2.0?
There are 2 correct answers to this question.
PKCS # 12 Kerberos SAML X.509X.
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?
Please choose the correct answer.
ABAP secure store file system (SSFS) xuser Secure store in file system (SSFS) hdbuserstore.
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 reload feature?
Please choose the correct answer.
Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false Edit the indexserver.ini file by setting the reload tables parameter in the sql section to false Edit the indexserver.ini file by setting the reload tables parameter in the sql section to true Edit the indexserver.xml file by setting the reload tables parameter in the sql section to false.
Which feature do you use to dynamically manage SAP HANA database workloads per client session?
Please choose the correct answer.
Workload classes Non-Uniform Memory Access (NUMA) Parallel execution of SQL statements Admission control.
What can you check with the SAP HANA hardware and cloud measurement tools (HCMT)?
There are 2 correct answers to this question.
NUMA memory bandwidth test Cloud connector status CPU states Linux kernel information.
You are running an SAP HANA database in log mode "normal". Under what circumstances does the database automatically execute a regular log backup?
There are 2 correct answers to this question.
When the time threshold is exceeded When the log segment is full When a commit occurs When the log buffer is full.
Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store?
There are 2 correct answers to this question.
SAP HANA tenant database replication Client-server communication over JDBC HTTPS client access using the SAP HANA Web Dispatcher Internal communication channels with the system PKI.
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.
sap <sid>adm Cockpit User Root Database User.
How can you perform a complete back up of an SAP HANA database system?
Please choose the correct answer.
Backup the complete storage system. Back up the system database and all tenant databases individually. Back up the complete database system. Back up the system database and all tenant databases in one step.
Which script can you trigger from SAP HANA cockpit to collect diagnosis information?
Please choose the correct answer.
hanachecker.py HanaHwCheck.py fullSystemInfoDump.py hanadumpviewer.py.
Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system?
There are 2 correct answers to this question.
Topology data on the location of tables and table partitions Monitoring data in the SYSTEMDB and all tenant databases Landscape topology data on the system as a whole Users and authorizations of the SYSTEMDB and all tenant databases.
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.
Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity. Having the data and log volumes on the different disks. Obtaining C_HANATEC_XX Certification. Obtaining the hardware certification from SAP for the existing hardware you are going to use.
Which operating system process takes care of starting the SAP HANA database system services?
Please choose the correct answer.
hdbdaemon sapstart hdbrsutil sapstartsrv.
You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?
Please choose the correct answer.
Before the migration After the migration After table creation Before table creation.
Which products do you use for SAP HANA administration?
There are 2 correct answers to this question.
SAP Solution Manager SAP Master Data Governance SAP HANA cockpit SAP Web IDE for SAP HANA.
How can you ensure that a consistent database status is saved using data snapshots?
Please choose the correct answer.
Create a fullback snapshot. Trigger a save point. Create an internal database snapshot. Execute the hdbbackupdiag tool.
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?
Please choose the correct answer.
100 GB 90 GB 025 GB 35 GB.
How do you ensure that Web-based applications send HTTPS requests to specific databases in an SAP HANA multiple-container system?
There are 2 correct answers to this question.
Check that all requests with physical hostnames are forwarded to tenant databases Check the hostnames mapping to internal HTTPS ports Configure an SAP Web Dispatcher for every tenant databases Configure an alias hostname for every tenant database.
What can you do to shorten the startup time of an SAP HANA system after a reboot?
Please choose the correct answer.
Set the preload column value in the Tables system table to FULL. Flag all columnar tables for preload. Partition the row store across nodes. Set the savepoint interval to a lower value.
A 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.
Recover the affected tenant first and then recover the system database. Recover the system database. The affected tenant is recovered automatically. Recover the system database first and then recover the affected tenant. Recover the affected tenant. The system database is NOT recovered.
What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?
Please choose the correct answer.
The primary system suspends transactions processing until the connection to the secondary system is established The primary system does NOT wait for confirmation of the secondary system The primary system waits until the secondary system confirms receiving the log The primary system waits until the secondary system confirms the log was persisted.
Which properties can you adjust in SAP HANA Admission Control?
There are 3 correct answers to this question.
Memory threshold for queuing new requests Memory limits for new SOL statement requests CPU threshold for rejecting new requests Maximum number of parallel 10 requests Maximum queue size for requests.
SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log?
There are 2 correct answers to this question.
queue_timeout record_limit queue_wait_time_threshold max_queue_size.
How are hosts assigned to the shared storage in the SAP HANA scale-out system?
There are 2 correct answers to this question.
The master node is assigned to all log volumes. The worker nodes are assigned to their own data volumes. The standby node is assigned to the worker data volume. The master node is assigned to its own data volume.
Who owns an SAP HANA Deployment Infrastructure (HDI) role?
Please choose the correct answer.
The container-specific technical user The user who created the role The _SYS_REPO technical user The SYSTEM user of the tenant database.
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.
Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION. Specify the user as the database user. Specify the name of the table/view. Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.
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.
The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added. The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
Which encryption services can you activate in SAP HANA?
There are 3 correct answers to this question.
Log Data Pages in-memory Backup Storage snapshot.
What is XS?
Please choose the correct answer.
A data cleansing engine An optional engine to handle excessive data loads A user interface A native, lightweight application server.
In which cases 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.
To optimize the standby node memory To extend the scale-out memory To actively free up memory To measure total table memory.
You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as an in-place migration. Which steps take place during downtime?
There are 2 correct answers to this question.
Creation of application tables in the target database in phase EU_CLONE_MIG_DT_CREATE XPRAS execution in phase XPRAS_AIMMRG Activation of dictionary objects in phase ACT_UPG Migration of application tables in phase EU_CLONE_MIG_DT_RUN.
You are running a database migration option (DMO) procedure using in-place migration. Where are the reading and writing R3load processes located during the actual migration?
Please choose the correct answer.
All of the reading and writing processes run on the primary application server (PAS) host. All of the reading and writing processes run on the target database host. The reading processes run on the primary application server (PAS) host; the writing processes run on the target database host. The reading processes run on the source database host; the writing processes run on the target database host.
Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes?
Please choose the correct answer.
1.0 TB 512 GB 1.5 TB 375 GB.
After confirming Lock now, which actions are still possible?
Please choose the correct answer.
Creating and changing application data (e.g. VA01) and user master records SU01) Developing via ABAP workbench (SE80) Applying SAP notes via Note Assistant (SNOTE) Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS).
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.
$(D1R INSTANCE)/backup/log $(DIR INSTANCE)//trace $(DIR INSTANCE)/backup/data $(DIR INSTANCE)/../global/hdb/custom/config.
Which role do you need in order to assign users to groups in the SAP HANA cockpit?
Please choose the correct answer.
Cockpit User Administrator Role Cockpit User Role Cockpit Administrator Role Cockpit Database Administrator Role.
Which SUM database migration option utility do you use to check and monitor table splitting?
Please choose the correct answer.
R3ta R3load utilization Log tail Viewer Table comparison.
Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header?
Please choose the correct answer.
hdb back int hdb backup diag hdb backup check Hdb recover check.
Which tools do you use to delete diagnosis files?
There are 2 correct answers to this question.
SAP HANA database explorer SAP HANA Web-based Development Workbench SAP HANA cleaner SAP HANA cockpit.
How do you trigger a savepoint in an SAP HANA database?
Please choose the correct answer.
Commit a transaction Execute a delta merge Start a log backup Perform a soft shutdown.
The recovery of your productive SAP HANA tenant database fails. In which cases can you resume the incomplete recovery?
There are 2 correct answers to this question.
Aborted recovery of a log backup Aborted recovery of the configuration files Aborted recovery of a complete data backup Aborted recovery of a delta data backup.
Which characteristics describe an SAP HANA multi-tenant database container (MDC) system?
There are 3 correct answers to this question.
Each tenant database runs its own compile server and the preprocessor server. A multitenant database container system is identified by a single system ID (SID). The name server provides index server functionality for the system database. Database isolation increases the isolation between tenant databases on operating system level. The name server owns information about the location of tables and table partitions in databases.
You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?
Please choose the correct answer.
A user with DATA ADMIN privileges and SELECT on _SYS TELEMETRY schema A multi tenant configuration with SYSTEMDB A user with CATALOG READ privileges and SELECT on SYS STATISTICS schema The target database on SAP HANA 2.0 SPS00 or higher.
Which connection types are allowed when you use system replication with the Active/Active option?
There are 2 correct answers to this question.
Explicit read and write on the secondary system Explicit read only on the secondary system Automatic round-robin statement routing Implicit hint-based statement routing.
Which tools are integrated into the SAP HANA cockpit?
There are 3 correct answers to this question.
SQL Console SQL Analyzer HDB Admin Database Explorer HANA Sitter.
What action(s) can you perform in the SAP HANA cockpit to back up the complete database system?
Please choose the correct answer.
Backup the system using a tailback snapshot for every database. Back up the system database and all tenant databases individually. Back up the system database and all tenant databases in one step. Backup the system using a database snapshot and a data snapshot.
Which prerequisites must you consider to add hosts to an SAP HANA scale-out system?
There are 2 correct answers to this question.
The additional host is placed in a different data center The host has access to the installation directories. The SAP HANA database server is shut down. The SAP HANA system installation should be on a shared file system.
Which of the following events occur while the merge operation is running?
There are 2 correct answers to this question.
The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage. All write operations go to the second delta storage. The content of the complete main storage is persisted to disk. Uncommitted changes in the first delta storage are rolled back.
Which is the relationship between the user group operators and the user groups?
There are 2 correct answers to this question.
Multiple user groups per user group operator Only one user group operator per user group Multiple user group operators per user group Only one user group per user group operator.
After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?
Please choose the correct answer.
It determines and rolls forward aborted transactions It reloads a savepoint with the restored consistent state of the database It rolls back changes of committed transactions that were NOT written to the data area It rolls back write transactions that were open when the database was stopped.
Why are repository roles preferred over catalog roles?
There are 2 correct answers to this question.
They are revoked if the database user that granted them is deleted. They are transportable runtime objects. They are transportable design-time objects. They are created by the technical user.
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.
When you need to measure total memory. When you need to optimize the standby node memory. When you need to extend the scale-out memory. When you need to actively free up memory.
Which information is provided via the SUM UI?
There are 3 correct answers to this question.
The content of log files via the log viewer The memory consumption of SUM A progress bar for the overall procedure The active roadmap step.
You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT_ MONITOR technical user?
There are 2 correct answers to this question.
CATALOG READ DATABASE ADMIN SELECT on the _SYS_TELEMETRY schema SELECT on the _SYS_STATISTICS schema.
What do you do to prepare the database migration option of a Software Update Manager procedure?
There are 3 correct answers to this question.
Extract the SAP HANA Client installation archive Move the SPAM update archive into the download folder Move the R3trans update archive into the download folder Move the stack.xml update file into the download folder Extract the SAP HANA database installation archive.
What software innovations did SAP deliver with SAP HANA?
There are 2 correct answers to this question.
Partitioning. Row and Delta store. Insert only on the Column store. Compression and Decompression.
What is included with the Predictive Analysis Library (PAL)?
There are 2 correct answers to this question.
Text mining functions Predictive algorithms Data preparation functions Flowgraphs.
Which of the following tasks requires the BACKUP ADMIN authorization?
There are 2 correct answers to this question.
Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location. Administration tasks executed on a tenant database through the system database. Recovering the database without a user interface Backing up the database without a user interface.
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.
Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence. Use the UPGANA.XML analysis file to optimize the number of R3load processes. Use the Test Cycle option to determine the optimal number of R3load processes. Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables.
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.
Create credentials for authenticated access to the target system. Create a tenant on the target system identical to the source system. Back up the source tenant database. Create credentials for authenticated access to the source system. Configure a secure connection from target system to source system.
How can you minimize the database migration option (DMO) downtime?
Please choose the correct answer.
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 Provide the measured table migration duration for table sequencing during benchmarking.
In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA?
There are 2 correct answers to this question.
SAP HANA as a platform for providing database and application services to native SAP HANA-' based applications. SAP HANA as a classic three-tier architecture as the primary database (for example. SAP NetWeaver Business Warehouse, SAP Business Suite Installation). SAP HANA as a data mart for reporting and analytics.
Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration?
Please choose the correct answer.
On the Primary Application Server (PAS) host On the remote target database host On the Additional Application Server (AAS) host On the source and target host.
Which technology is utilized by the Performance Warehouse option in the transaction DBACOCKPIT?
Please choose the correct answer.
SAP Analytics Cloud SAP Intelligent Query (SAP IQ) SAP Business Intelligence SAP Data Warehouse Cloud.
Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol (LDAP) server?
There are 2 correct answers to this question.
Password policy configuration Role assignment User group assignment User creation.
What cryptographic libraries are supported in SAP HANA by default?
There are 2 correct answers to this question.
Common Cryptolib OpenSSL Libgcrypt WolfCrypt.
Which update methods can you use to minimize the business downtime during the upgrade of an SAP HANA database?
There are 2 correct answers to this question.
Database migration options of SUM Export/import using SAP Provisioning Manager Phases update Near Zero Downtime.
Which diagnostic file can you use to monitor the status of database recovery?
Please choose the correct answer.
backup.Iog backint.Iog sapstartsrv. Log available.log.
How can the system database administrator disable tenant database functionalities?
Please choose the correct answer.
Using the Manage Blacklisted Parameter app Using the Manage Restricted Features app Using the hdbuserstore tool Using the resident hdblcm tool.
What can you use the Secure User Store (hdbuserstore) for?
There are 2 correct answers to this question.
To configure failover supporting a 3-tier scenario To store connection information on the SAP HANA database client To store connection information on the SAP HANA XS Advanced engine To configure an SAP HANA Auto-Restart Fault Recovery Support.
You are planning an SAP S/4HANA scale-out system. What are the minimal size requirements for CPU and memory?
Please choose the correct answer.
RAM: >= 4TB, CPU: >= 8 RAM: >= 6TB, CPU: >=12 RAM: >= 6TB, CPU: >= 8 RAM: >= 8TB,CPU: >=12.
Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required?
There are 2 correct answers to this question.
Bi-directional communication channels User sharing User mapping Communication channel whitelist.
Your customer asks you to set up alert monitoring in SAP HANA cockpit 2.0. Which alert properties can you configure?
There are 2 correct answers to this question.
Schedule activation Check interval Threshold values Proposed solution.
You need to update the location where a copy of the persistent data is saved. Which of the following parameters do you change?
There are 2 correct answers to this question.
basespath_export basepath_databackup Basepathjogmirror Basepathjogbackup.
Which system privilege do you need to redistribute tables across the hosts in a scale-out system?
Please choose the correct answer.
DATA ADMIN WORKLOAD ADMIN OPTIMIZER ADMIN RESOURCE ADMIN.
Which of the following users are able to start and stop a distributed SAP HANA Database System?
There are 2 correct answers to this question.
ADM user SYSTEM user ROOT.
Which target database does the SUM databases migration option provide by default?
There are 2 correct answers to this question.
SAP ASE SAP IQ SAP HANA SAp MaxDB.
What is the correct sequence of the following four steps when you restart the SAP HANA database system?
Please choose the correct answer.
1. Aborted transactions are rolled back.
2. Open transactions are recovered.
3. Row tables are loaded into memory.
4. Column tables are loaded.
1. Row tables are loaded into memory.
2. Open transactions are recovered.
3. Aborted transactions are rolled back.
4. Column tables are loaded.
1. Row tables are loaded into memory.
2. Column tables are loaded.
3. Open transactions are recovered.
4. Aborted transactions are rolled back.
1. Aborted transactions are rolled back.
2. Row tables are loaded into memory.
3. Open transactions are recovered.
4. Column tables are loaded.
.
Which technology does the SAP DBA Cockpit use to store the performance indicators?
Please choose the correct answer.
SAP Adaptive Server Enterprise SAP Intelligent Query SAP Analytics Cloud SAP Business Intelligence.
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?
Please choose the correct answer.
The latest log backup The last full data backup The latest incremental backup The last commited transaction.
You need to integrate an existing SAP HANA2.0 SPS05 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?
Please choose the correct answer.
In the SYSTEMDB and all tenants In the SYSTEMDB and the first tenant In the SYSTEMDB In the first tenant.
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?
There are 2 correct answers to this question.
Create the OS user obs on the application server Create the database user obs on the application server Provide the sum observer URL to SAP support Provide the SUM URL to SAP support.
Which default users will be created during the installation of the SAP HANA database system?
There are 2 correct answers to this question.
ldapadm <sid>crypt sapadm sap<sid>.
You investigate a hung SAP HANA database, and you CANNOT identify the blocking transactions. What causes could lead to this behavior?
There are 2 correct answers to this question.
An issue with the delta merge A long savepoint duration A wrong role of a service in a failover situation A setting to restrict CPU usage.
Which migration features are supported when using the database migration option (DMO) of Software Update Manager (SUM)?
There are 2 correct answers to this question.
A database migration from SAP HANA to SAPASE can be performed. A database migration from Oracle to SAP Max DB can be performed. The SAP system can be AS Java-based if tl1e release is 7.50 or higher. The primary application server (PAS) can be moved to a target system landscape.
Which tool do you use to backup the root encryption keys?
Please choose the correct answer.
Rsecssfx Hdbnsutil Hdbuserstore Dbacockpit.
What do you require to perform a migration using the SUM database migration option?
There are 2 correct answers to this question.
OS/DB certified consultant Migration check Services Stack.xml file Migration key.
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.
Multitenant database containers (MDC) Multiple Components on One System (MCOS) Multiple Components on One Database (MCOD) Technical co-deployment (TCD).
Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database?
Please choose the correct answer.
External Interfaces Request Processing and Execution Control Storage Engine and Disk Storage Relational Engines.
You need to periodically monitor if the SAP HANA primary system is online. Which tool do you use?
Please choose the correct answer.
systemreplicationStatus hanasitter landscapeHostConfiguration HDBAdmin.
Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system.
Which of the following options are listed?
There are 3 correct answers to this question.
Security Performance Management Memory Management Resource Management Monitoring and Administration.
When performing a standard SAP HANA database system installation, which users will be created or validated during that installation?
There are 2 correct answers to this question.
SAP<SID> SYSTEM <sid>crypt sapadm.
Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option?
There are 2 correct answers to this question.
The content comparison is performed for repository tables. The clustered tables are decluttered. A check sum is generated every 10000 rows. A row count is executed for the migrated tables.
What is the recommended size for the log volume file system for a 512 GB SAP HANA database system?
Please choose the correct answer.
512 GB 427 GB 256 GB 614 GB.
What can a user do when the backup operator system privileges is assigned?
Please choose the correct answer.
Schedule backups Delete backups Configure backup settings Perform data recovery.
Which programming languages are supported when you develop an application on SAP HANA extended application services?
There are 2 correct answers to this question.
Lisp.js Node.js ABAP C++.
Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure?
There are 2 correct answers to this question.
Move the latest R3trans update archive into the download folder. Check if the latest SPAM/SAINT update is applied. Extract the SAP HANA database software installation archive. Update the SAP Host Agent to the latest version.
Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server?
There are 2 correct answers to this question.
User mapping Role assignment User creation Password policy configuration.
Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system?
Please choose the correct answer.
On 1 Off 0.
Which hardware KPls 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 question.
Network bandwidth for the storage zone DRAM required for the static data memory area Total disk space required for the log volume Persistent memory (PMEM) required for backups.
Which administration tool can you use to start and stop the SAP HANA database system?
Please choose the correct answer.
SAP Landscape Management SAP HANA HDBSQL SAP Solution Manager DBA Cockpit.
Which certificates do you require for a trusted secure communication between the client and the SAP HANA database?
There are 2 correct answers to this question.
Server certificate X.509 certificate User certificate Root certificate.
Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel?
There are 2 correct answers to this question.
Both must have the same SAP HANA version. Both systems are located in the same data center. The CPU architecture must be identical. An explicit read-only connect on between both systems must be available.
The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?
Please choose the correct answer.
Standby memory Physical memory Virtual memory Resident memory.
Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media?
There are 2 correct answers to this question.
Update the SAP HANA database system and its components. Rename the SAP HANA database system. Extract the SAP HANA database system components. Uninstall the SAP HANA database system and its components.
What is a prerequisite when you install the SAP Landscape Management tool?
Please choose the correct answer.
SAP HANA XS Advanced SAP NetWeaver Application Server Java SAP NetWeaver Application Server ABAP SAP Fiori launchpad.
Which parameters do you need to change before you can analyse the memory usage of running SQL statements?
There are 2 correct answers to this question.
memory_tracking statement_memory_limit use_in_memory_tracing enable_tracking.
Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit?
There are 2 correct answers to this question.
Delta backup Full backup Fall back snapshot Data snapshot.
What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication?
Please choose the correct answer.
It takes place in addition to continuous log replay. It takes place with continuous read-only access to the secondary system. It takes place in addition to continuous log shipping. It takes place every 5 minutes.
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting?
Please choose the correct answer.
The Observer Monitor The R3LDCTL The Process Bucket monitor The Log viewer.
Which SAP HANA cockpit application can you use to investigate a system offline situation?
There are 2 correct answers to this question.
CPU usage monitor Full system information dumps Out-of-memory event monitor Troubleshoot unresponsive system.
Where is the name server running in a multitenant database container system?
Please choose the correct answer.
Standby node SYSTEMDB Each tenant Master node.
The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions, and threads?
There are 2 correct answers to this question.
PerfTrace.py Troubleshoot unresponsive systems Manage full system information dumps emergencylnfo.py.
Which information can you collect by running the fullSystemInfoDump.py script when the SQL connection is available?
Please choose the correct answer.
A selection of .trc files A selection of rows of schema SAP<SID> A selection of .log files A selection of rows of schema _SYS_XS.
You set up email notification for a specific alert threshold by using Alerts Configuration. When is the email notification sent?
There are 2 correct answers to this question.
When the alert checker identifies an issue When the alert checker is turned off When the alert checker identifies a resolved issue When the alert checker identifies a recurring issue.
Which action do you perform when the data area in an SAP HANA database is running out of space?
Please choose the correct answer.
Create a new database volume Extend the file system size in the operating system level Create a new tenant database Extend the size of the database volume.
Which services are located in a tenant database?
Please choose the correct answer.
Compile server Name server Web Dispatcher Index server.
Which feature do you configure to prevent the whole SAP HANA database system from reaching physical processing limits?
Please choose the correct answer.
Admission control Performance trace Capture and replay Workload classes.
What can you directly assign to a user with the Manage Users app in SAP HANA cockpit?
There are 2 correct answers to this question.
Privileges Scopes Roles Role collections.
How are savepoints triggered?
There are 2 correct answers to this question.
By a database soft shutdown. By performing a database backup. By issuing a transactional commit. By performing a delta merge.
Which scale-out roles can you assign to the hosts in the nameserver.ini file?
There are 2 correct answers to this question.
WORKER SLAVE MASTER 1 STANDBY.
Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database?
There are 2 correct answers to this question.
Table partitions can be distributed over all nodes. The columns of a table can be distributed over all nodes. The row store can be distributed over all nodes. Cross-node joins must be avoided.
You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?
Please choose the correct answer.
Runtime Repository Monitoring Modeling.
Which of the following are characteristics of SAP HANA Smart Data Streaming?
Please choose the correct answer.
It provides reports and analysis on the received data. It acts based on combinations of events. It is a standalone product for use with any target system. It uses database queries.
What additional action do you need to perform after you create a new tenant in an SAP HANA system replication configuration?
Please choose the correct answer.
Back up the tenant database. Restart the secondary system. Copy the tenant database. Start the tenant database.
Which parameters are mandatory when using the hdblcm tool in batch mode?
There are 2 correct answers to this question.
Installation path Data and Log path Password of the user sapadm SAP HANA System ID (SID).
What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)?
There are 2 correct answers to this question.
Memory configuration Kernel settings Missing OS patches Network configuration.
Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?
There are 2 correct answers to this question.
Daemon Index server Compile server Preprocessor.
Where is SDI used?
There are 2 correct answers to this question.
Data transformation Data cleansing Data streaming For data loading.
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?
Please choose the correct answer.
Installation config screen Installation log file Installation logs screen COCKPIT ADMIN user logs.
Which SAP HANA features can you use to manage the database peak load?
There are 2 correct answers to this question.
Capture and replay Admission control Thread throttling Workload classes.
What are prerequisites for changing the SSFS Master Keys?
There are 2 correct answers to this question.
You have the credentials of the Operating system user adm that was created when the system was installed You have the system privilege I IN I FILE ADMIN You have the server root privilege INIFILE ADMIN You have the credentials of the SYSTEM 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.
Temporary license keys are manually installed by the SAP HANA system After 90 days, the temporary license expires and the system is locked down Temporary license keys are automatically installed by the SAP HANA system After 28 days, the temporary license expires and the system is locked down.
Which package of SAP HANA cloud platform provides a vast set of platform services for the most common pattern in software engineering, such as persistence, connectivity, identity and document management?
Please choose the correct answer.
SAP HANA Enterprise Cloud SAP HANA DBServices SAP HANA AppServices SAP HANA Infrastructure Services.
vWhich tools can you use to start and stop tenants in an SAP HANA database?
There are 2 correct answers to this question.
SAP HANA Studio - System view sapcontrol hdbsql SAP HANA cockpit 2.0 - Manage Databases.
Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned?
Please choose the correct answer.
Balance table distribution Redistribute tables after adding host(s) Check the correct location of tables and partitions Check the number of partitions.
You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup?
There are 2 correct answers to this question.
After the configured time threshold has been exceeded When a savepoint occurs NI When the log buffer is full When the log segment is full.
You install a productive multi-host system with failover capabilities. Which storage condition prerequisites must be ensured?
There are 2 correct answers to this question.
The standby host has file access The failed worker host has access to write files The failed worker host no longer has access to write to files The standby host has NO file access.
The design-time version of a security role can contain which of the following information?
There are 2 correct answers to this question.
The users assigned by default to this role The role name The users assigned to the role The privileges assigned to the role.
What are the advantages of the DMO procedure?
There are 3 correct answers to this question.
DMO combines several steps into one procedure. DMO is an inplace procedure by default, keeping the application server host. DMO allows an easy reset during the procedure. DMO allows a lower target release on SAP HANA database.
In which replication mode is the primary system blocked until the secondary system is available?
Please choose the correct answer.
Async syncmem full sync Sync.
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.
The failed worker host no longer has access to write to files The standby host has file access The standby host has access to write to files SYSTEM users replaced by standby host.
Which connections do you need to enable explicitly for a Restricted User?
There are 2 correct answers to this question.
JDBC ADO.NET OLEDB ODBC.
Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool?
There are 3 correct answers to this question.
Store the logon credentials of the replayer user in the secure store. Preprocess the captured workload on the source system. Restore the source system tenant backup to the target tenant. Create a replayer user account in the target database system. Create a replayer user account on the target operating system.
Which of the following system privileges can you assign to an SAP HANA database user?
There are 3 correct answers to this question.
EXPORT EXECUTE CREATE SCHEMA DEVELOPMENT CREATE ANY.
Which of the following actions are audited by default in SAP HANA?
There are 2 correct answers to this question.
Creation, modification or deletion of audit policies Deletion of audit entries from the audit trail Installation of SAP HANA license Changes to system configuration.
How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?
Please choose the correct answer.
Set up cross-database access control Set database isolation levels to high Assign internal communication ports Edit the configuration change blacklist.
Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES?
There are 2 correct answers to this question.
Procedures Schemas Functions Views.
Which rules should you consider when creating a table distribution plan for SAP Business Suite powered by SAP HANA to get the best possible results?
There are 2 correct answers to this question.
Keep the number of key column low. Keep all partitions on different hosts. Keep the number of partitions per table high. Keep the number of partitioned tables low.
Which trace do you use to create a graphical representation of an individual SQL Statement?
Please choose the correct answer.
Performance trace Plan trace Expensive statements trace SQL trace.
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases?
There are 2 correct answers to this question.
The user in the source system must be associated with a user in the target database. The user in the source system must have sufficient privileges in the target database. The cross-tenant database communication must be explicitly activated. The bidirectional communication channel must be whitelisted.
Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory?
There are 2 correct answers to this question.
total_statement_memory_limit statement_memory_limit memory_tracking reject_memory_threshold.
You created a restricted user in the DB1 database. Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user?
There are 3 correct answers to this question.
ALTER USER <USERNAME> ENABLE CLIENT CONNECT ALTER USER GRANT CREATE ANY ON OWN SCHEMA ALTER USER <USERNAME> GRANT ROLE PUBLIC ALTER USER <USERNAME> ADD REMOTE IDENTITY ALTER USER <USERNAME> ACTIVATE USER NOW.
How can you optimize the Database Migration Option (DMO) procedure downtime for a production system?
There are 2 correct answers to this question.
Provide the measured table migration duration data for optimal table sequencing during benchmarking. Set the optimal number of R3load processes during benchmarking and the DMO procedure. Use the benchmarking option to find the optimal throughput during the DMO procedure. Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.
Which of the following SAP HANA capability allows you to load and replicate data in real time from ABAP source systems and non-ABAP source systems to an SAP HANA environment?
Please choose the correct answer.
SAP HANA smart data streaming SAP HANA dynamic tiering SAP HANA landscape transformation replication server SAP HANA remote data sync.
Why do we still need a persistent layer?
There are 2 correct answers to this question.
To store data that is frequently used To store data that has been unloaded from memory To enable full database recovery if we have a power failure To hold the delta store for newly arrived records.
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?
There are 2 correct answers to this question.
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 schedules with the SAP HANA cockpit Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules.
Which of the following recovery types is not supported for delta backups?
Please choose the correct answer.
Recover the database to a specific point in time. Recover the database to its most recent state. Recover the database to a specific data backup.
Which backup and recovery scenario is allowed in multitenant database containers? The system database should be recovered first in order to recover the tenant databases. A backup of a tenant database can be recovered to the system database. A tenant database can initiate its own backup, but the system database executes the recovery. After the recovery of a tenant database, the system database needs a backup.
Your SAP HANA database is locked down. Which action can you still perform?
Please choose the correct answer.
Check database license Configure system properties Check session memory Check overall database status.
Which actions can you perform using the SAP HANA platform lifecycle management web user interface?
There are 2 correct answers to this question.
Configure the system landscape directory registration. Update the SAP HANA database system. Manage the full system information dumps. Stop and start the SAP HANA database system.
Which of the following elements are valid rules for the location of the backup files?
There are 3 correct answers to this question.
The backup ID is unique for each persistence only. The backup files should never be in the same directory and on the same file system as u data. The Volume ID is automatically added to a specified file name. The backup folder will be created automatically when the backup process is started.
You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager.
Which processes can you adjust in the advanced mode to speed up the migration?
There are 2 correct answers to this question.
TP SAPup R3trans SQL.
Where can you check the trace and log files when your SAP HANA database is NOT available?
There are 2 correct answers to this question.
In the Trace app of the SAP HANA Web-based Development Workbench In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0 In the Diagnosis Files app of the SAP HANA cockpit for offline administration In the /usr/sap/<SID>/HDB<instance number>/<host>/trace path on the operating system.
Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)?
There are 3 correct answers to this question.
Measurement of the data throughput between CPU and DRAM Validation of the LPAR configuration settings on IBM Power servers Validation of the operating system configuration settings for the Linux kernel Measurement of data throughput between the Linux kernel and CPU Measurement of data throughput between SAP HANA nodes and storage.
Which schema provides performance data and alert details to review in SAP HANA mini checks?
Please choose the correct answer.
_SYS_STATISTICS _SYS_SQL_ANALYZER COCKPIT_MONITOR SAP_XS_USAGE.
Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit?
There are 2 correct answers to this question.
CATALOG READ SELECT on the _SYS_TELEMETRY schema RESOURCE ADMIN SELECT on the _SYS_STATISTICS schema.
Which user credentials are required when performing a database migration option (DMO) procedure to SAP HANA 2.0?
There are 3 correct answers to this question.
User DDIC of client 000 of the SAP system User DBACOCKPIT of the target tenant database User SYSTEM of the target system database User SAP of client 000 of the SAP system S-user for the SAP Support Portal.
What are the prerequisites for using the Web user interface for HDBLCM?
There are 2 correct answers to this question.
The SAP HANA database is revision 90 or higher internet Explorer - Version 8 or higher The communication port 1329 is open The communication port 1129 is open.
Which operation is executed before a table is repartitioned?
Please choose the correct answer.
Delta merge Reorganization Snapshot Savepoint.
What are the merge methods that are triggered by the SAP HANA system processes?
There are 2 correct answers to this question.
Smart Hard Critical Auto.
One of your systems shows the internal Disk Full (Alert 30) alert. What is the root cause of this alert?
Please choose the correct answer.
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 Running out of free space on the /hana/shared volume.
Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?
There are 2 correct answers to this question.
The source database is up and running. The DMO procedure hasn't reached downtime yet. The SUM folder needs to exist. A cleanup has already been triggered.
Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)?
There are 3 correct answers to this question.
Rename the SAP HANA Database hostname Transport application changes Uninstall the individual components Rename the SAP HANA database system Remove host roles.
Which connection type is used by default for restricted users?
Please choose the correct answer.
HTTP/S OLEOS ODBC JDBC.
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 2 TB nodes in an SAP HANA scale-out system consisting of three worker and one standby nodes?
Please choose the correct answer.
1 TB 3 TB 0.5 TB 1.5 TB.
Which activities do you have to carry out to configure your multi-tenant database container (MDC) system to a higher database isolation level between tenant databases on the operating system (OS)?
There are 3 correct answers to this question.
Add dedicated tenant OS users to the sapsys group. Create dedicated tenant OS users for each tenant. Add dedicated tenant OS users to the <sid> shm group. Remove the <sid> adm OS user from the sapsys group. Lock the adm OS user.
Which option do you choose to protect your SAP HANA scale-out system using host autofailover?
Please choose the correct answer.
Automatic savepoint System replication Storage replication Standby node.
Which technology is used to install the SAP Landscape Management tool?
Please choose the correct answer.
SAP NetWeaver Application Server for Java SAP Fiori launchpad SAP HANA XS advanced runtime SAP NetWeaver Application Server for ABAP.
You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?
Please choose the correct answer.
indexserver.ini global.ini nameserver.ini multidb.ini.
How are user group administrators and user groups related?
There are 2 correct answers to this question.
Multiple user groups per user group administrator Only one user group administrator per user group Only one user group per user group administrator Multiple user group administrators per user group.
Which SAP HANA database service can you stop from the system database?
There are 2 correct answers to this question.
Index server Compile server Preprocessor XS Engine.
What is the minimum space requirement for the Data Volume?
There are 2 correct answers to this question.
Min. 0.5 * RAM Min. 1 * RAM 1.2 * RAM (TDI) 3 * RAM (Appliance).
Which alert configuration properties can you configure in SAP HANA cockpit?
There are 3 correct answers to this question.
Email alert notification Alert threshold values Schedule period Schedule activation Alert checker category.
What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario?
There are 3 correct answers to this question.
Input/output operations per second (IOPS) Network throughput Persistent storage SAP Application Performance Standard (SAPS) Main memory.
Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit?
There are 3 correct answers to this question.
Sandbox Test Development Custom Production.
Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned?
Please choose the correct answer.
Check the number of partitions Balance table distribution Redistribute tables after adding host(s) Check the correct location of tables and partitions.
Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit?
There are 2 correct answers to this question.
Diagnosis information Runtime environment SAP HANA minichecks End-to-end Trace.
What are some of the characteristics of the design-time role?
There are 3 correct answers to this question.
The role is granted through the execution of stored procedures. The role is granted and revoked directly by the database user. The role can be transported between systems. The role is revoked if the grantee user is deleted. The role is created by technical user _SYS_REPO.
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?
There are 2 correct answers to this question.
enable_tracking threshold_cpu_time load_monitor_granularity cpu_time_measurement_mode.
Where do you investigate a failed uninstall of an SAP HANA scale-out system?\
Please choose the correct answer.
/usr/sap//hostctrl/work NI /var/tmp/hdblcm.log /hana/shared/log /hana/log/<SID>.
How can I troubleshoot HANA installer when it crashes?
There are 2 correct answers to this question.
set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename run hdblcm with the check installation action activate the debug mode for the database trace create the directory containing the trace file.
Which features do you need to activate before you can analyze the memory usage of running SQL statements?
There are 2 correct answers to this question.
Statement memory limit Memory tracking Tracking In-memory tracing.
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.
The function can return multiple values. The function must be of the type scalar. The input parameter must be set to mandatory. The generated value can be overwritten at runtime.
Which system privileges are required for administering tenant databases when being connected to the system database?
There are 2 correct answers to this question.
MONITOR ADMIN BACKUP ADMIN DATA ADMIN DATABASE ADMIN.
Which table provides a customizing interface that can be used for the dynamic management of partitions and locations?
Please choose the correct answer.
EFFECTIVE_TABLE_PLACEMENT UPDATE_LANDSCAPE_CONFIGURATION TABLE_PLACEMENT TABLE_GROUP.
The SAP HANA database is NOT reachable, and the root cause is unclear. Which SAP HANA cockpit functions allow you to investigate this situation?
There are 2 correct answers to this question.
Troubleshoot unresponsive system Manage full system information dumps Overall database status Open blocked transactions.
|
