ADNAN - SPS04

Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer. The _SYS_REPO technical user. The user who created the role. The container-specific technical user. The SYSTEM user of the tenant database.

What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer. SAP NetWeaver Application Server Java. SAP HANA XS Advanced. SAP NetWeaver Application Server ABAP. SAP Fiori launchpad.

Which characteristics describe an SAP HANA Multiple Database Container (MDC) System? There are 3 correct answers to this question. The name server provides index server functionality for the system database. Each tenant database runs its own compile server and the preprocessor server. The Database Isolation increases the isolation between tenant databases on the operating system level. The name server owns information about the location of tables and table partitions in databases. A Multiple Database Container system is identified by a single System ID (SID).

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 bidirectional communication channel must be whitelisted. The cross-tenant database communication must be explicitly activated.

Which prerequisites must you consider to add hosts to an SAP HANA scale-out system? There are 2 correct answers to this question. The SAP HANA database server is shut down. The host has access to the installation directories. The additional host is placed in a different data center. The SAP HANA system installation should be on a shared file system.

How can the system database administrator disable tenant database functionalities? Please choose the correct answer. Using the hdbuserstore tool. Using the Manage Blacklisted Parameter app. Using the Manage Restricted Features app. Using the resident hdblcm tool.

How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer. Create a fullback snapshot. Create an internal database snapshot. Trigger a save point. Execute the hdbbackupdiag tool.

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 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. SELECT on the _SYS_STATISTICS schema. SELECT on the _SYS_TELEMETRY schema. CATALOG READ. RESOURCE ADMIN.

Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question. BACKUP ADMIN. MONITOR ADMIN. DATA ADMIN. DATABASE ADMIN.

Which file system locations are suggested to install an SAP HANA multi-host system? There are 2 correct answers to this question. /hana/shared. /hana/<sid>. hana/log/<sid>. /hana/<hostname>.

Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to this question. Keep all partitions on different hosts. Keep the number of partitions per table high. Keep the number of key columns low. Keep the number of partitioned tables low.

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 in one step. Back up the system database and all tenant databases individually. Back up the complete database system.

Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question. Maximum request queue size. Maximum parallel 10 requests. CPU threshold for rejecting requests. Memory limit for queuing requests. SQL statement request memory limit.

What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question. >= 8TB. >= 6TB. >= 12CPU. >= 8CPU.

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.

How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question. Use the benchmarking option to find the optimal throughput during the DMO procedure. Set the optimal number of R31oad processes during benchmarking and the DMO procedure. Provide the measured table migration duration data for optimal table sequencing during benchmarking. Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.

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. Back up the source tenant database. Configure a secure connection from target system to source system. Create a tenant on the target system identical to the source system. Create credentials for authenticated access to the target system. Create credentials for authenticated access to the source system.

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 actively free up memory. When you need to optimize the standby node memory. When you need to extend the scale-out memory.

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? There are 3 correct answers to this question. 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. Add dedicated tenant OS users to the sapsys group.

Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? There are 2 correct answers to this question. HTTPS client access using the SAP HANA Web Dispatcher. Client-server communication over JDBC. SAP HANA tenant database replication. Internal communication channels with the system PKI.

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. Sapcontrol. hdbcons. HDBAdmin. HANASitter.

Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer. Cockpit Administrator. Cockpit User. Cockpit User Administrator. Cockpit Resource Administrator.

In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question. When the log segment is full. When a commit occurs. When the log buffer is full. When the time threshold is exceeded.

Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question. Preprocessor. XS Engine. Index server. Compile server.

Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question. Procedures. Sequences. Views. Tables.

What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question. Critical. Auto. Smart. Hard.

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. 375 GB. 1.5 TB. 512 GB. 1.0 TB.

How are hosts assigned to the shared storage in an SAP HANA scale-out system? There are 2 correct answers to this question. The master server is assigned to all data volumes. The standby server is assigned to the master data volume. The slave servers are assigned to their own data volumes. The master name server is assigned to its master data volume.

What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? Please choose the correct answer. Delta data shipping takes place in addition to continuous log replay. Delta data shipping takes place in addition to continuous log shipping. Delta data shipping takes place every 5 minutes. Delta data shipping takes place with continuous read-only access to the secondary system.

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.

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. Page Management and logger. Metadata Manager and Transaction Manager. Column Store and Row Store. Session Management and log Volumes.

Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question. Measurement of data throughput between SAP HANA nodes and storage. Validation of the LPAR configuration settings on IBM Power servers. Measurement of the data throughput between CPU and DRAM. Validation of the operating system configuration settings for the Linux kernel. Measurement of data throughput between the Linux kernel and CPU.

Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question. Alert checker category. Schedule period. Alert threshold values. Email alert notification. Schedule activation.

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. max_queue_size. record_limit. queue_wait_time_threshold. queue_timeout.

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 Additional Application Server (AAS) host. On the source and target host. On the remote target database host.

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 last commited transaction. The latest log backup. The latest incremental backup. The last full data backup.

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. BACKUP OPERATOR. DATABASE ADMIN. TENANT ADMIN. BACKUP ADMIN.

Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question. ldapadm. sapadm. <sid>crypt. sap<sid>.

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. 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.

Which prerequisites are necessary for productively using SAP HANA cockpit 2.0? There are 2 correct answers to this question. 16 GB RAM on a dedicated server. 10 GBit/s network bandwidth. An Intel-based system with operating system Microsoft Windows. An IBM Power System with operating system SUSE Linux Enterprise Server (SLES).

What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system?. Obtaining C_HANATEC_XX Certification. Obtaining the hardware certification from SAP for the existing hardware you are going to use. Having the data and log volumes on the different disks. Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.

SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer. A restart of the primary system. An upgrade of the secondary system. An upgrade of the primary system. A restart of the secondary system.

Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer. _SYS_SQL_ANALYZER. _SYS_STATISTICS. _SYS_TELEMETRY. _SYS_WORKLOAD_REPLAY.

How are savepoints triggered? There are 2 correct answers to this question. By issuing a transactional commit. By performing a delta merge. By a database soft shutdown. By performing a database backup.

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. SQL. R3trans. TP. SAPup.

Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer. The Log viewer. The Process Bucket monitor. The Observer Monitor. The R3LDCTL.

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. Error. Initializing. Unknown.

Which backup and recovery scenario is allowed in multitenant database containers?. A tenant database can initiate its own backup, but the system database executes the recovery. The system database should be recovered first in order to recover the tenant databases. After the recovery of a tenant database, the system database needs a backup. A backup of a tenant database can be recovered to the system database.

Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question. Only one user group per user group operator. Only one user group operator per user group. Multiple user groups per user group operator. Multiple user group operators per user group.

In which scenario do you need SAP expert sizing? There are 2 correct answers to this question. Carving out ERP functionality from the source system to the ERP on SAP HANA system. Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA. Customers are new to SAP applications and SAP HANA. Consolidating multiple ERP source systems into one ERP system on SAP HANA.

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. Scopes. Roles. Privileges. Role collections.

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. Network throughput. Persistent storage. Input/output operations per second (IOPS). SAP Application Performance Standard (SAPS). Main memory.

Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? There are 2 correct answers to this question. Uninstall SAP HANA database components. Extract components. Update SAP HANA and its components. Rename the SAP HANA database system.

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 re-partitioned? Please choose the correct answer. Redistribute tables after adding host(s). Balance table distribution. Check the correct location of tables and partitions. Check the number of partitions.

Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer. RESOURCEADMIN. WORKLOAD ADMIN. DATABASE ADMIN. INIFILE ADMIN.

Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question. GPFS. XFS. MPFS. EXT3.

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. Sandbox. Test. Custom. Production.

Which types of backups can you use to copy an SAP HANA tenant? There are 2 correct answers to this question. Fallback snapshot. Delta database backup. Full database backup. Data snapshot.

Which products do you use for SAP HANA administration? There are 2 correct answers to this question. SAP Master Data Governance. SAP Solution Manager. SAP Web IDE for SAP HANA. SAP HANA cockpit.

Which system privilege must you have to redistribute tables across the hosts in your scale-out system? Please choose the correct answer. RESOURCE ADMIN. OPTIMIZER ADMIN. DATA ADMIN. WORKLOAD ADMIN.

Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer. SAP Intelligent Query. SAP Analytics Cloud. SAP Adaptive Server Enterprise. SAP Business Intelligence.

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 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB. For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB. For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB. For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB.

What is the additional disk space factor required during delta merge operations? Please choose the correct answer. 1.2. 1.6. 3.0. 4.0.

Which prerequisites must be fulfilled when recovering a tenant database? There are 2 correct answers to this question. The whole system is shut down, including all tenant databases. Before the recovery starts, the tenant database must be stopped. You need the logon credentials of the <sid> adm user. You need the logon credentials of the system database user.

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. statement_memory_limit. memory_trackin. enable_tracking. use_in_memory_tracing.

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 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 systems are located in the same data center. Both must have the same SAP HANA version. The CPU architecture must be identical. An explicit read-only connect on between both systems must be available.