What is the correct sequence of the following four steps when you restart the SAP HANA database system?
Please choose the correct answer. 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. Row tables are loaded into memory.
3. Open transactions are recovered.
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. Open transactions are recovered.
3. Row tables are loaded into memory.
4. Column tables are loaded.
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_SOT_DUR.XML file to manually optimize table splitting of large tables. 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_DT_DUR.XML file to optimize table splitting and migration sequence.
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: >= 6TB, CPU: >= 8 RAM: >= 4TB, CPU: >= 8 RAM: >= 6TB, CPU: >= 12 RAM: >= 8TB, CPU: >= 12.
What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes?
Please choose the correct answer. Metadata Manager and Transaction Manager Page Manager and logger Column Store and Row Store Session Management and log Volumes.
Where is the name server running in a multitenant database container system?
Please choose the correct answer. Standby mode SYSTEMDB Master node Each tenant.
In which situations can you resume the failed recovery of your productive SAP HANA tenant database?
There are 2 correct answers to this question. An aborted recovery of the configuration files An aborted recovery of a log backup An aborted recovery of a complete data backup An aborted recovery of delta data backup.
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. 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. 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.
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. /usr/sap/hostctrl /usr/sap/<SID> /hana/shared /hana/log/<SID>.
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. XFS GPFS Btrfs OCFS2.
Which SAP HANA cockpit application can you use to investigate a system offline situation?
There are 2 correct answers to this question. Full system information dumps. Out-of-memory event monitor troubleshot unresponsive system CPU usage monitor.
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 DATABASE ADMIN BACKUP ADMIN DATA ADMIN.
What are the merge methods that are triggered by the SAP HANA system processes?
There are 2 correct answers to this question. Critical Hard Smart Auto.
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 clustered tables are decluttered. A check sum is generated every 10000 rows. The content comparison is performed for repository tables. A row count is executed for the migrated tables.
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_treshold may_queue_size.
Which services are located in a tenant database?
Please choose the correct answer. Web Dispatcher Index server Name server Compile server.
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.5 TB 0.5 TB 3 TB 1 TB.
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 partitions per table high. Keep all partitions on different hosts. Keep the number of key column low. Keep the number of partitioned tables low.
Which prerequisites are necessary for productively using SAP HANA cockpit 2.0?
There are 2 correct answers to this question. 10 GBit/s network bandwidth 16 GB RAM on a dedicated server An intel-based system with operating system Microsoft Windows An IBM Power System with operating system SUSE Linux Enterprise Server (SLES).
You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration. Which steps take place during downtime?
There are 2 correct answers to this question. XPRaS execution in phase XPRAS_AIMMRG Creation of application tables in the target database in phase EU_CLONE_MIG_DT_CREATE Activation of dictionary objects in phase ACT_UPG Migration of application tables in phase EU_CLONE_MIG_DT_RUN.
Which properties can you adjust in SAP HANA Admission Control?
There are 3 correct answers to this question. Maximum number of parallel request Memory limits for new SQL statement requests Memory threshold for queuing new request Maximum queue size for requests CPU threshold for rejecting new requests.
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.
Which connections do you need to enable explicitly for a Restricted user?
There are 2 correct answers to this question. ODBC JDBC OLEDB ADO.NET.
What is the purpose of the SAP HANA secure user store (hdb user store)?
There are 2 correct answers to this question. To store connection information on the SAP HANA XS advanced engine To store connection information on the SAP HANA database client To configure an SAP HANA auto-restart for fault recovery To configure failover support in a 3-tier scenario.
Which operating system process takes care of starting the SAP HANA database system services.+?
Please choose the correct answer. sapstartsrv sapstart hdbrsutil hdbdaemon.
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.
What are the supported operating systems for SAP HANA in IBM Power Servers?
There are 2 correct answers to this question. For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2 For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6.210 For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15 For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 and SP4.
Which prerequisites must be fulfilled to rename a tenant database in SAP HANA cockpit?
There are 2 correct answers to this question. The tenant database is not part of move operation. The tenant database is stopped. The tenant database must be unloaded from memory. The on-disk tenant directory should be a mount point.
Which feature do you configure to prevent the whole SAP HANA database system from reaching physical processing limits?
Please choose the correct answer. Workload classes Capture and replay Admission control Performance trace.
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. Roles Privileges Role collections Scopes.
Which backup and recovery scenario is allowed in multitenant database containers?
Please choose the correct answer. After the recovery of a tenant database, the system database needs a backup. A tenant database can initiate its own backup, but the system database executes the recovery. Thy 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.
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.
What is 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 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 <sid> shm group. Create dedicated tenant OS users for each tenant. Remove the <sid> adm OS user from the sapsys group. Add dedicated tenant OS users to the sapsys group. Lock the adm OS user.
Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?
Please choose the correct answer. INFILE ADMIN WORKLOAD ADMIN DATABASE ADMIN RESOURCE ADMIN.
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 system database user. You need the logon credentials of the <sid> adm user. The whole system is shut down, including all tenant databases. Before the recovery starts, the tenant database must be stopped.
What is the first node limit for planning an SAP S/4HANA scale-out system?
There are 2 correct answers to this question. <= 8CPU <= 8TB <= 12CPU <= 6TB.
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.
What can you check with the SAP HANA hardware and cloud measurement tools (HCMT)?
There are 2 correct answers to this questions. Cloud connector status CPU states NUMA memory bandwidth test Linux kernel information.
In which scenario do you need SAP expert sizing?
There are 2 correct answers to this question. Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA When migrating existing SAP ERP systems from Any DB to run on SAP HANA Customer is new to SAP ERP applications and the SAP HANA database system Carving out SAP ERP functionality from the source system to the SAP ERP system on SAP HANA.
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 back snapshot Data snapshot Full backup.
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 tne number of partitions Balance table distribution Redistribute tables after adding host(s) Check the correct location of tables and partitions.
Which types of backup can you use to copy an SAP HANA tenant database?
There are 2 correct answers to this question. Delta database backup Full database backup Data snapshot Fallback snapshot.
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. Development Production Sanbox Custom Test.
The SAP HANA database system is not available through the SQL interface. Which option do you have to collect information to monitor connections, transactions, blocked transactions, and threads?
There are 2 correct answers to this question. Troubleshot unresponsive systems PerfTrace.py manage full system information dumps emergencyInfo.py.
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. Configure a secure connection from target system to source system. Create credentials for authenticated access to the target system. Create credentials for authenticated access to the source system. Backup the source tenant database. Create a tenant on the target system identical tothe source system.
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. Moniitoring Repository Runtime Modeling.
Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?
There are 2 correct answers in this question. A cleanup has already been triggered. The DMO procedure hasn't reached downtime yet. The SUM folder needs to exist. The source database is up and running.
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. <sid>crypt SAP<SID> sapadm SYSTEM.
Which system usage types are automatically assigned to ties in the SAP HANA cockpit?
There are 3 correct answers to this question. Quality assurance Custom Development Test Production.
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 Internal communication channels with the system PKI Client-server communication over JDBC HTTPS client access using the SAP HANA Web Dispatcher.
Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA 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. An explicit read-only connect on between both systems must be available. The CPU architecture must be identical.
Which characteristics describe an SAP HANA multi-tenant databse container (MDC) system?
There are 3 correct answers to this question. A multitenant database container system is identified by a single system ID (SID). The name server provides index server functionality for the system database. The name server owns information about the location of tables and tale partitions in databases. Each tenant database runs its own compile server and the preprocessor server. Database isolation increases the isolation between tenant databases on operating system level.
Which connection type is used by default for restricted users?
Please choose the correct answer. ODBC JDBC HTTP/S OLEOS.
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. Role assignment User group assignment Password policy configuration User creation.
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. SELECT on the SYS_STATISTICS schema SELECT on the SYS_TELEMETRY schema DATABSE ADMIN CATALOG READ.
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. Initializing Unknown Error Syncing.
What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication?
Please choose the correct answer. 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. It takes place in addition to continuous log replay.
Which SAP HANA database service can you stop from the system database?
There are 2 correct answers to this question. XS Engine Preprocessor Compile server Index server.
Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server?
There are 2 correct answers to this question. Role assignment User mapping Password policy configuration User creation.
Which default users will be created during the installation of the SAP HANA database system?
There are 2 correct answers to this question. <sid>crypt sapadm sap<sid> ldapadm.
Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system?
There are 2 correct answers to this questions. DRAM required for the static data memory area Network bandwidth for the storage zone Persistent memory (PMEM) required for backups Total disk space required for the log volume.
Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure?
There are 2 correct answers to this question. Extract the SAP HANA database software installation archive. Update the SAP Host Agent to the latest version. Check if the latest SPAM/SAINT update is applied. Move the latest R3trans update archive into the download folder.
What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAM HANA database system?
There are 2 correct answers to this questions. Obtaining the hardware certification from SAP for the existing hardware you are going to use. Obtaining C_HANATECH_XX Certification. 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.
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 actions take place during a database migration option (DMO) procedure when performing an in-place migration?
There are 2 correct answers to this question. TABART is considered for the creation of R3load control files. De-pooling of tables is done during the procedure. One table is migrated per R3load pair. SAP up decides which tables to split.
Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?
There are 2 correct answers to this question. Preprocessor Index server Compile server Daemon.
Which alert configuration properties can you configure in SAP HANA cockpit?
There are 3 correct answers to this question. Alert checker category Schedule period Email alert notification Schedule activation Alert threshold values.
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 a commit occurs When the log buffer is full When the log segment is full.
What is the correct minimum requirement for log volume and /hana/shared/ file system for an SAP HANA database system?
Please choose the correct answer. For 512 GB system, Log volume = 512 GB, /hana/shared/ = 256 GB For 256 GB system, Log volume = 128 GB, /hana/shared/ = 256 GB For 2 TB system, Log volume = 1 TB, /hana/shared/ = 1 TB For 1 TB system, Log volume = 1 TB, /hana/shared/ = 1 TB.
Which table holds the data used for the dynamic management of partitions and locations?
Please choose the correct answer. TABLE_GROUP TABLE_PLACEMENT UPDATE_LANDSCAPE_CONFIGURATION EFFECTIVE_TABLE_PLACEMENT.
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 1 TB nodes in an SAP HANA scale-out system with three worker and one standby node?
Please choose the correct answer. 1.0 TB 1.5 TB 512 GB 256 GB.
Which role do you need in order to assign users to groups in the SAP HANA cockpit?
Please choose the correct answer. Cockpit User Role Cockpit User Administrator Role Cockpit Administrator Role Cockpit Database Administrator Role.
How can you perform a complete back up of an SAP HANA database system?
Please choose the correct answer. Back up the system database and all tenant databases in one step. Back up the system database and all tenant databases individually. Back up the complete database system. Back up the complete storage system.
What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)?
There are 2 correct answers to this question. Memory configuration Network configuration Kernel settings Missing OS patches.
Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES?
There are 2 correct answers to this question. Functions Views Schemas Procedures.
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. Persistent storage Main memory Network throughput SAP Application Performance Standard (SAPS) Input/Output operations per second (IOPS).
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. Cockpit User sap <sid>adm Root Database User.
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. statement_memory_limit memory_tracking total_statement_memory_limit reject_memory_threshold.
Which tools are integrated into the SAP HANA cockpit?
There are 3 correct answers to this question. HDB Admin Database Explorer SQL Console SQL Analyzer HANA Sitter.
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. Memory tracking In-memory tracing Statement memory limit Tracking.
|
