|What is the correct sequence of the following four steps in the restart of the SAP HANa database system? 1.Aborted transactions are rolled back
2.Row tables are loaded into memory
3.Open transactions are recovered
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.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.Column tables are loaded
3.Open transactions are recovered
4.Aborted transactions are rolled back.
Which privileges are assigned automatically when you create a techincal user during the register resource procedure in SAP HANA cockpit?
Note: There are 2 correct answers to this question SELECT one the _SYS_TELEMETRY schema CATALOG READ RESORUCE ADMIN SELECT on the _SYS_STATISTICS schema.
Which preparation steps do you need to perform before replaying a captured workload using the SAP HANA catpure and replay tool?
Note: there are 3 correct answers to this question Resource the source system tenant backup to the target tenant Preprocess the captured workload on the source system Create a replayer user account in the target database system Store the logon credentials of the replayer user in the secure store Create a replayer user account on the target operating system.
Which products do you use for SAP HANA administration?
Note: there are 2 correct answers to this question SAP Solution Manager SAP Hana Cockpit SAP Master Data Governance SAP Web IDE for SAP HANA.
Which backup and recovery scenario is allowed in multitenant database container? A tenant database can initiate its own backup, but the system database executes the recovery A backup of a tenant database can be recovered to the system database The system database should be recovered first in order to recover the tenant database After the recover of a tenant database, the system database needs a backup.
Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Upgrade Manager (SUM)?
Note there are 2 correct answers to this question The source system is Application Server (AS) Java-based The Primary Application Server can be move to a target system Landscape The target database is SAP Adaptive Server Enterprise (ASE) The source and target database system are of the same type.
In which scenario do you need SAP expert sizing?
Note: there are 2 correct answers to this question Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA Consolidating multiple ERP source systems into one ERP system on SAP HANA Carving out ERP functionality from the source system to the ERP on SAP HANA system Customers are new to SAP applications and SAP HANA.
Which preparation tasks do you need to performe before starting the Database Migrations Options (DMO) procedure?
Note: there are 2 correct ansers to this question Exctract the SAP Hana database software installation archive Check if the latest SPAM/SAINT update is applied Move the latest R3trans update archive into the download folder Update the SAP Host Agent to the latest version.
What is the first node limit for planning an SAP S/4 HANA scale-out system?
Note: there are 2 correct ansers to this question >=8TB >=8CPU >=6TB >=12CPU.
Which default users will be created during the installation of the SAP HANA database?
Note: there are 2 correct answers to this question ldadpadm <sid>crypt sap <sid> sapadm.
In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup?
Note: there are 2 correct answers to this question When the log buffer is full When a commit occurs When the log segment is full When the time threshold is exceeded.
What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system?
Note: there are 2 correct answers to this question Obtaining C_HANATEC_XX certification Having 10Gbit/s for storage zone and 1 Gbit/s for internal zone for network connectivity Obtaining the hardware certification from SAP for the existing hardware you are going to use Having the data and log volumes on different disks.
Which parameters are mandatory when using the hdblcm tool in batch mode?
Note: there are 2 correct answers to this question SAP HANA System ID (SID) Data and log path Installation path Password of the user sapadm.
What are the supported operating systems for SAP HANA on IBM Power Servers?
Note: there are 2 correct answers to this question For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10 For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2 For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15 For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4.
Which database objects can you manipulate if you have the ALL PRIVILEGES activity?
Note: there are 2 correct answers to this question Views Tables Sequences Procedures.
Which tool do you use to investigate an SAP HANA sustem that is started but can't be reached using SQL?
Note: there are 2 correct answers to this question hdbcons HANASitter HDBAdmin Sapcontrol.
During the delta merges process, to which memory area si data inserted?
Note: there are 2 correct answers to this question Main 2 Delta 2 Main 1 Delta 1.
Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit?
Note: there are 2 correct answers to this question Diagnosis information Runtime environment SAP HANA minichecks End-to-end Trace.
Which SAP HANA trace must you activate to analyze performance issues with systems where thirdy-part software cannot be installed? End-to-End SQL Kernel profiler User-Specific.
What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Restart secondary system Copy tenant database Start tenant database Back up tenant database.
Which checks are executed when you run the Hardware Configuration Check Tool (HWCCTL)?
Note: there 3 correct answers to this question Measurement of data throughput between the Linux kernel and the CPU Measurement of the data throughput between CPU and DRAM Measurement of data throughput between SAP HANA nodes and storage Validation of the LPAR configuration settings on IBM Power servers Validation of the operating systems configurations settings for the Linux kernel.
Which preparation tasks do you need to perorm before starting the copy and move process for a tenant database?
Note: there 3 correct answers to this question Back up the source tenant database Create a tenant on the target system identical to the source system Create credential for authenticated access to the source system Create credential for authenticated access to the target system Configure a secure connection from target system to source system.
How can you perform a complete back up of an SAP HANA database system? Backup the complete storage system Back up the system database and all tenant databases individually. Back up the system database and all tenant databases in one step. ack up the complete database system.
What are the merge methods that are triggered by the SAP HANA system process?
Note: there are 2 correct answers to this question Hard Critical Smart Auto.
What is a prerequisite when you install the SAP Landscape Management Tool? SAP Fiori Launchpad SAP Netweaver Application server Java SAP Netweaver Application server Abap SAP HANA XS Advanced.
How can you optimize the Database Migration Option (DMO) peocedure downtime for a production system?
Note: there are 2 correct answers to this question Set the optimal number of R3load processes during benchmarking and the DMO procedure Provide the measured table migration duration data for optimal table sequencing during benchmarking Using the benchmarking option to fine the optimal throughput during the DMO procedure Use the Test Cycle option to fine the optimal number of R3load processes on a test run.
Which types of backups can you use to copy an SAP HANA tenant? (2 answers) Delta database backup Fallback snapshot Data snapshot Full database backup.
What is the correct minimum requirement for log volume and /hana/shared file system for an SAP HANA database system? For 2TB systems, Log Volume = 1 TB, /hana/shared = 1 TB For 256GB systems, Log Volume = 128 GB, /hana/shared = 256 GB For 512 GB systems, Log Volume = 512 GB, /hana/shared = 256 GB For 1 TB systems, Log Volume = 1 TB, /hana/shared = 1 TB.
Which prerequisites must you consider to rename a tenant database in the SAP HANA cockpit? (2 answers) The tenant database is stopped. The on-disk tenant directory should be a mount point. The database that is not in move operation. The tenant database must be unloaded from memory.
What is a charateristic of the Delta Data Shipping operation mode in SAP HANA system replication? Delta Data Shipping takes place with continuous read-only access to the secondary system Delta Data Shipping takes place in addition to continuous log shipping Delta Data Shipping takes place every 5 minutes Delta Data Shipping takes place in addition to continuous log replay.
Which parameters do you need to change before you can analyse the memory usage of running SQL statements? (2 answers) enable_tracking use_in_memory_tracing statement_memory_limit memory_tracking.
Which is the relationship between the user group operators and the user groups? (2 anwers) Only one user group operator per user group Multiple user groups per user group operator Multiple user group operator per user group Only one user group per user group operator.
When can you load and unload indivual tables and table columns manually in an SAP HANA tenant database? (2 answers) When you need to actively free up memory When you need to optimize the stanby node memory When you need to extend the scale-out memory When you need to measure the total memory.
Which filesystem locations are suggested to install an SAP HANA multi-host system? (2 answers) /hana/log/<sid> /hana/<sid> /hana/shared /hana/<hostname>.
The recovery of your productive SAP HANA tenant database fails. In which cases can you resume the incomplete recovery? (2 answers) Aborted recovery of a delta data backup Aborted recovery of a complete data backup Aborted recovery of the configuration files Aborted recovery of a log backup.
Which file systems are supported for the SAP HANA database system? (2 answers) EXT3 XFS GPFS MPFS.
Which rules should you consider when creating a table distribution plan for SAP Buisness Suit on SAP HANA to get the best possibile results? (2 answers) Keep the number of partitioned tables low Keep the numbers of key columns low Keep the number of partions per table high Keep all partiotions on different hosts.
What can you directly assign to a user with the Manage User app in Sap Hana Cockpit? (2 answers) Privileges Role collections Roles Scopes.
What can you use the Secure User Store (hdbuserstore) for? (2 answers) 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 Autorestart Fault Recovery Support.
Which system privilege must you have to manage blacklisted parameters in SAP HANA cockpit? WORKLOAD ADMIN DATABASE ADMIN RESOURCE ADMIN INIFILE ADMIN.
In a Multiple Database Container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases? BACKUP ADMIN DATABASE ADMIN BACKUP OPERATOR TENANT ADMIN.
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? The R3LDCTL The Process Bucket monitor The Observer Monitor The Log viewer.
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? (2 answers) An explicit read-only connect on between both systems must be available. Both must have the same SAP HANA version The CPU architecture must be identical. Both systems are located in the same data center.
Whic SAP HANA features can you use to manage the database peak load? (2 answers) Admission control Thread throttling Capture and replay Workload classes.
Which connections do you need to enable explicitly for a Restricted User? (2 answers) ADO.NET ODBC OLEDB JDBC.
Which SAP HANA database service can you stop from the system database? (2 answers) XS Engine Compile Server Preprocessor Index server.
How are savepoints triggered? (2 answers) By a database soft shutdown. By performing a database backup By performing a delta merge By issuing a transactional commit.
Which prerequisistes are necessary for productively using SAP HANA Cockpit 2.0? (2 answers) 10 Gbit/s network bandwidth An Intel-based system with operating system Microsoft Windows 16 GB RAM on dedicated server An IBM Power System with operating system SUSE Linux Enterprise Server (SLES).
Which properties can you adjust in SAP HANA Admission Control? (3 answers) Memory limit for queuing requests SQL statement request memory limit CPU threshold for rejecting requests Maximum request queue size Maximum parallel 10 requests.
Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? (2 answers) Update SAP HANA and its components. Rename the SAP HANA database system. Uninstall SAP HANA database components. Extract components.
Who owns an SAP HANA Deployment Infrastructure (HDI) role? The container-specific techincal user The user who created the role The _SYS_REPO techical user The SYSTEM user of the tenant database.
Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? (2 answers) Internal communication channels with the system PKI Client-server communication over JDBC SAP HANA tenant database replication HTTPS client access using the SAP HANA Web Dispatcher.
Which tables provides a customizing interface that can be used for the dynamic management of partitions and locations? EFFECTIVE_TABLE_PLACEMENT UPDATE_LANDSCAPE_CONFIGURATION TABLE_GROUP TABLE_PLACEMENT.
Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface? (2 answers) Communication port 1129 is open. SAP HANA database system in any version. Installed SAP Host Agent on the SAP HANA host. SAP HANA Client software locally installed.
How are hosts assigned to the shared storage in an SAP HANA scale-out system? (2 answers) The standby server is assigned yo the master data volume The master name server is assigned to its master data volume. The master server is assigned to all data volumes The slave servers are assigned to their own data volumes.
Which technology does the SAP DBA Cockpit use to store the performance indicators? SAP Adaptive Server Enterprise SAP Intelligent Query SAP Analytics Cloud SAP Business Intelligence.
How can the system database administrator disable tenant database functionalities? Using the resident hdbclm tool Using the hdbuserstore tool Using the Manage Blacklisted Parameter app Using the Manage Restricted Features app.
What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Page Management and logger Column Store and Row Store Metadata Manager and Transaction Manager Session Management and log Volumes.
You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system? Unknown Syncing Error Initializing.
Which replication modes keeps the primary system waiting until a timeout is exceeded when the secondary system is not available? (2 answers) ASYNC SYNC SYNCMEM FULL SYNC.
Which system privileges are required for administrating tenant databases when being connected to the system database? (2 answers) MONITOR ADMIN BACKUP ADMIN DATA ADMIN DATABASE ADMIN.
Which role do you need in order to assign users to groups in SAP HANA cockpit? Cockpit Administraor Cockpit Resource Administrator Cockpit User Administrator Cokcpit User.
Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? 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.
What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? (2 answers) Network configuration Kernel settings Memory configuration Missing OS patches.
Your customer has purchased a 1.5 TB SAP HANA license. To wich value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1 TB nodes in an SAP HANA scale-out system with three worker and one standy nodes? 512 GB 375 GB 1.0 TB 1.5 TB.
Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? (3 answers) 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 prerequisites must be fulfilled when recovering a tenant database? (2 answers) Before the recovery starts, the tenant database must be stopped. You need the logon credentials of the system database user. The whole system is shut down, including all tenant databases You need the logon credentials of the <sid> adm user.
Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA Cockpit? (3 answers) Test Sandbox Development Custom Production.
How can you ensure that a consistent database status is saved using data snapshots? Execute the hdbbackupdiag tool Trigger a savepoint Create a fallback snapshot Create an internal database snapshot.
Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? (3 answers) The DBACOCKPIT user of the tenant database The SYSTEM user of the system database The SAP user in client 000 of the ABAP system The S-user for the SAP Support Portal connection The DDIC user in client 000 of the ABAP system.
Which system schema provides performance data adn system alert detail to review in SAP HANA Mini checks? _SYS_STATISTICS _SYS_WORKLOAD_REPLAY _SYS_SQL_ANALYZER _SYS_TELEMETRY.
Which alert configuration properties can you configure in SAP HANA cockpit? (3 answers) Alert checker category Schedule period Alert threshold values Schedule activation Email alert notification.
Which user management tasks can be performed by a Lightweight Directory Acess Protocol (LDAP) server? (2 answers) Role assignment User creation User mapping Password policy configuration.
Which charateristics describe an SAP HANA Multiple database Container (MDC) System? (3 answers) The name server provides index server functionality for the system database The name server owns information about the location of tables and table partitions in database The Database Isolation increases the isolation between tenant databases on the operating system level Each tenant database runs its own compile server and the preprocessor server A Multiple Database Container system is identified by a Single System ID (SID).
Which system privilege must you have to redistribute tables across the hosts in your scale-out system? WORKLOAD ADMIN DATA ADMIN RESOURCE ADMIN OPTIMIZER ADMIN.
Which prerequisites must you consider to add hosts to an SAP HANA scale-out system? (2 answers) The additional hosts is placed in a different data center The SAP HANA database is shut down The hosts has access to the installation directories The SAP HANA system installation should be on a shared files ystem .
What is the additional disk space factor required during delta merge operations? 1.6 1.2 3.0 4.0.
Which parameters do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? (2 answers) statement_memory_limit total_statement_memory_limit reject_memory_threshold memory_tracking.
Which SAP HANA cockpit application can you use to investigate a system offline situation? CPU usage monitor Full system information dump Out-of-memory event monitor Troubleshoot unresponsive system.
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? (2 answers) The bidirectional communication channel must be whitelisted. The user in the source system must have sufficient privileges in the target database. The cross-tenant database communication must be explicitly activated. The user in the source system must be associated with a user in the target databse.