C-hanatec-05

What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers. OS/DB certified consultant. Migration check Services. Migration key. Stack.xml file.

Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question. Admission control. Capture and replay. Thread throttling. Workload classes.

You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup? Note: There are 2 correct answers. When a savepoint occurs. When the log buffer is full. After the configured time threshold has been exceeded. When the log segment is full.

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 Test Cycle option to determine the optimal number of R3load processes. Use the UPGAN XML analysis file to optimize the number of R3load. Use the UPGAN XML analysis file to optimize the number of R3load. Use the MIGRATE_SOT_DU XML file to manually optimize table splitting of large tables.

What cryptographic libraries are supported in SAP HANA by default? There are 2 correct answers to this question. OpenSSL. Common Cryptolib. WolfCrypt. LibgCrypt.

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. An upgrade of the primary system. An upgrade of the secondary system. A restart of the secondary system. A restart of the primary system.

You install SAP HANA for productive usage, but the installation stops because the hardware check failed. How do you resolve this issue?. Use SAP HANA database lifecycle manager (HDBLCM) to edit the configuration. Use a hardware configuration listed in the Product Availability Matrix. Run the HanaHwCheck.py script before resuming the installation. Use the hdbinst command to install the SAP HANA database directly.

Which SUM database migration option utility do you use to check and monitor table splitting?. Table comparison. R3load utilization. Log tail Viewer. R3ta.

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. Specify the name of the table/view. Select INFO from the System Trace Level for the Index server component and then select AUTHORIZATIO. Specify the user as the database user. Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATIO.

Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers. Backup. Data. Log. Pages in-memory. Storage snapshot.

To ensures that the database can be restored to the most recent committed state after a restart which of the following Index server components make sure such consistency and maintain durable changes?. Storage Engine. Disk Storage. Relational Engines. Relational Engines.

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

Which of the following tools can be used for User Administration? There are 3 correct Answers to this question. SAP NetWeaver Identity Management. hdbsql. Resident hdblcm. SAP HANA Cockpit.

Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers. To persist in-memory data. To ensure maximum performance. To enable database scale-up. To allow a restart if the power fails.

A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer. recover the system database and the affected tenant with the initialize log area option. restore the database and recover the affected tenant upto moment of the problem. recover the affected tenant upto moment of the problem. recover the affected tenant with the initialize log area option.

What are advantages of column store tables? There are 3 correct answers to this question. Columns can be partitioned. Only the columns required are actually loaded to memory. They are optimized for high-volume read /write transactional processing. Data footprint is automatically reduced through compression.

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. sap<sid>. Idapadm. sapadm.

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?. hdbuserstore. xuser. Secure store in file system (SSFS). ABAP secure store file system (SSFS).

SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question. Create a restricted user. Assign a user to a user group. Create and delete users. Lock and unlock users.

What can a user do when the backup operator system privileges is assigned?. Schedule backups. Delete backups. Configure backup settings. Perform data recovery.

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. RecoverStateCheckerpy. sap control. HDBAdmin.

Which target database does the SUM databases migration option provide by default? Note: There are 2 correct answers. SAp MaxDB. SAP ASE. SAP IQ. SAP HANA.

Which migration features are supported when using the database migration option (DMO) of Software Update Manager (SUM)? (Choose two.). A database migration from SAP HANA to SAP ASE can be performed. The SAP system can be AS Java-based if the release is 7.50 or higher. the primary application server (PAS) can be moved to a target system landscape. A database migration from Oracle to SAP MaxDB can be performed.

You install a productive multi-host system with failover capabilities . Which storage condition prerequisites must be ensured? Note: There are 2 correct answers. the standby host has file access. The standby host has NO file access. The failed worker host has access to write files. The failed worker host no lonqer has access to write to files.

How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?. Edit the configuration change blacklist. Set up cross-database access control. Set database isolation levels to high. Assign internal communication ports.

Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correct answers to this question. Delta Backup. Backup of Configuration files. Data Backup. Data Snapshot.

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?. Multiple Components on One Database (MCOD). Multitenant database containers (MDC). Technical co-deployment (TCD). Multiple Components on One System (MCOS).

Which trace do you use to create a graphical representation of an individual SQL Statement?. Performance trace. Expensive statements trace. SQL trace. Plan trace.

What can you do to shorten the startup time of an SAP HANA system after a reboot?. Flag all columnar tables for preload. Set the savepoint interval to a lower value. Set the preload column value in the Tables system table to FULL. Partition the row store across nodes.

In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?. Indexserve.ini. Nameserver.ini. Multidb.ini. Sapprofile.ini.

What can you assign to a user with the User Management app in SAP HANA cockpit? There are 2 correct answers to this question. User group. LDAP authorization mode. Scopes. LDAP identity provider.

You setup email notification for a specific alert threshold by using Alerts Configuration. When are the email notification sent? Note: There are 2 correct answers. When the alert checker identifies an issue. When the alert checker identifies a resolved issue. When the alert checker is turned off. When the alert checker identifies a recurring issue.

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 system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

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. Persistent memory (PMEM) required for backups. Total disk space required for the log volume. Network bandwidth for the storage zone.

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 operator per user group. Multiple user groups per user group operator. Multiple user group operators per user group. Only one user group per user group operator.

The SAP HANA database is NOT reachable, and the root cause is unclear . Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers. Troubleshoot unresponsive system. Overall database status. Manage full system information dumps. Open blocked transactions.

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?. Installation log file. COCKPIT_ADMIN user logs. Installation logs screen. Installation config screen.

In which circumstances do you create a column store table? There are 3 correct answers to this question. When the calculations are based on a small number of columns. When aggregations or fast search is required. When accessing complete records. When the table has a large number of columns.

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

Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?. Manage Databases. Manage Services. Manage Services. Performance Monitor.

What do you do to prepare the database migration option of a Software Update Manager procedure? Note: There are 3 correct answers. Move the SPAM update archive into the download folder. Extract the SAP HANA Client installation archive. Move the stack.xml update file into the download folder. Extract the SAP HANA database installation archive. Move the R3trans update archive into the download folder.

What is the additional disk space factor required during delta merge operations. 1.2. 4.0. 3.0. 1.6.

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

Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? Note: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.

How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question. run hdblcm with the check_installation action. set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename. create the dirctory containing the trace file. activate the debug mode for the database trace.

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

Which SAP HANA cockpit application can you use to investigate a system offline situation? Please choose the correct answer. CPU usage monitor. Troubleshoot unresponsive system. Full system information dump. Out-of-memory event monitor.

Which script can you trigger from SAP HANA cockpit to collect diagnosis information?. HanaHwCheck.py. fullSystemlnfoDump.py. hanachecker.py. hanadumpviewer.py.

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. SYSTEM users replaced by standby host. 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.

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

Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question. Service auto-restart. Storage replication. Host auto-failover. Auto log backups.

Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question. Set the password for the system database user. Create an operating system user for the converted tenant database. Trigger the conversion in the SAP HANA cockpit 2.0. Generate the system database before the conversion.

ou must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers. Which rules apply? There are 2 correct answers to this question. The system database must run on the standby host. The system database instance must run on all hosts (worker and standby). The tenant databases must be able to be scaled out to all hosts (worker and standby). The tenant databases must run on the worker hosts.

Which SUM database migration option utility do you use to check and monitor table splitting?. R3ta. Log tail Viewer. Table comparison. R3load utilization.

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 system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

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? Note: There are 2 correct answers. Create the tenant in the target database. Recover the tenant with the Initialize Log Area option. Copy the transaction logs to the target database. Start the recovered tenant database.

What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question. Kernel settings. Network configuration. Memory configuration. Missing OS patches.

What is the correct sequence of the following four steps in the restart of 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. Aborted transactions are rolled back. 1Row 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.Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.

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

Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers. Rename the SAP HANA Database hostname. Remove host roles. Transport application changes. Rename the SAP HANA database system. Uninstall the individual components.

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? Note: There are 2 correct answers. threshold_cpu_time. cpu_time_measurement_mode. load_monitor_granularity. enable_tracking.

Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor? There are 3 correct answers to this question. Memory and CPU consumption from the SAP HANA database. Disk consumption from the SAP HANA database. Connection statistics about open connections. The time at which the database was started.

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 SAP ABAP kernel on the application server. The DBACOCKPIT user on the SAP HANA database. The updated BRTOOLS on the non-SAP database. The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database. The shadow schema on the non-SAP database.

Which administration tool can you use to start and stop the SAP HANA database system?. SAP HANA HDBSQL. DBA Cockpit. SAP Solution Manager. SAP Landscape Management.

What is a prerequisite for a system replication when the development (DEV) system and the quality (QA) system are installed on the secondary site?. The DEV and QA systems must be online during system takeover. The preload of tables must be switched off. The global allocation limit must be identical. The SIDs and instance numbers must be identical.

Which connection is used when you view or edit alerts in the Configure Alerts app using SAP HANA cockpit 2.0. The https connection with the <sid>adm user. The https connection with the system user. The SQL connection with a technical user. The SQL connection with a named user.

You migrate a database to SAP HANA using the database migration option. Which tool do you use to split tables?. R3load. SAPinst. R3ta. SAPup.

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. Measurement of data throughput between the Linux kernel and CPU. 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.

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? Note: There are 2 correct answers to this question. TP. SQL. SAPup. R3trans.

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

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). Main memory. Network throughput. Persistent storage. SAP Application Performance Standard (SAPS).

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

Which actions are performed during the database migration option (DMO) procedure when you select the ‘Do not compare table contents’ option? (Choose two.). The clustered tables are declustered. A check sum is generated every 10000 rows. A row count is executed for the migrated tables. The content comparison is performed for repository tables.

How are user group administrators and user groups related? (Choose two.). Only one user group per user group administrator. . Multiple user groups per user group administrator. Multiple user group administrators per user group. Only one user group administrator per user group.

Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? (Choose two.). Extract the SAP HANA database system components. Update the SAP HANA database system and its components. Uninstall the SAP HANA database system and its components. Rename the SAP HANA database system.

Which migration features are supported when using the database migration option (DMO) of Software Update Manager (SUM)? (Choose two.). A database migration from SAP HANA to SAP ASE can be performed. The SAP system can be AS Java-based if the release is 7.50 or higher. The primary application server (PAS) can be moved to a target system landscape. A database migration from Oracle to SAP MaxDB can be performed.

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?. All of the reading and 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. The reading processes run on the primary application server (PAS) 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.

What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers. Takeover time is shorter. CPU load is reduced. Network traffic is reduced. Memory consumption is lower.

Which of the following statements are true about SAP HANA Live? There are 2 correct answers to this question. SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases, and not on live operational reporting. SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution. SAP HANA Live for SAP Business Suite is an accelerator. SAP HANA Live for SAP Business Suite comprises of an Analytical Model. SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite.

Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question. Migrating to a target database, g. SAP HANA. Performing an SAP software update. Performing a Unicode conversion. Performing a database upgrade of the source database.

You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?. A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema. A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema. A multitenant configuration with SYSTEMDB. The target database on SAP HANA 2.0 SPS00 or higher.

Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are 2 correct answers. Persisted redo logs. Automatic savepoints. Memory allocation limit. Delta merge.

Which option do you choose to protect your SAP HANA scale-out system using host autofailover?. System replication. Automatic savepoint. Storage replication. Standby node.

Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?. DBA Cockpit. hdblcm. hdbsql. SAP HANA cockpit.

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. A row count is executed for the migrated tables. The content comparison is performed for repository tables. A check sum is generated every 10000 rows. The clustered tables are decluttered.

Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option?. A row count is executed for the migrated tables. The content comparison is performed for repository tables. A check sum is generated every 10000 rows. The clustered tables are decluttered.

Which information is provided by the backup catalog. Please choose the correct. Backup destination. Progress of a backup. Backup configuration. Backup ID.

Why do we still need a persistent layer? There are 2 correct answers to this question. 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. To store data that is frequently used.

Which information is recorded in the database trace of the SAP HANA database?. Executed SQL statements on database level. Performance indicators on a query level. Database activities with the trace level ERROR. Query execution plans on an application level.

Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question. The source and target database system are of the same type. The Primary Application Server can be moved to a target system Landscape. The target database is SAP Adaptive Server Enterprise (ASE). The source system is Application Server (AS) Java-base.

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. Proposed solution. Schedule activation. Threshold values. Check interval.