SAP SAP Certifications C_HANATEC141 Questions & Answers

• Question 11:

  You are using the Change and Transport System (CTS) with SAP HANA. When is the transport strategy determined?

  A. When the objects are attached to a transport request in the SAP HANA studio

  B. When the SAP HANA application type is configured in CTS

  C. When the connection to CTS is configured in SAP HANA studio

  D. When the export system is configured in CTS

  Correct Answer: D

• Question 12:

  Which of the following traces provides information about past SQL query runtime performance including the values of parameters?

  A. Expensive statements trace

  B. Performance trace

  C. User-specific trace

  D. SQL trace

  Correct Answer: A

• Question 13:

  In the SAP HANA studio, to which of the following does the loading status "partially" refer?

  A. To a row store table that is loaded in delta storage

  B. To a column store table that is loaded in delta storage

  C. To a row store table of which only some rows are loaded

  D. To a column store table of which only some columns are loaded

  Correct Answer: D

• Question 14:

  Which of the following tools can you use to create and manage SAP HANA database users? (Choose two)

  A. SAP Solution Manager

  B. Microsoft Active Directory

  C. SAP Netweaver Identity Management

  D. hdbsql

  Correct Answer: CD

• Question 15:

  You want the user SOLMAN_ADMIN to be able to modify the properties of the SAP HANA instance during system configuration in SAP Solution Manager.

  Which role must you assign to the user SOLMAN_ADMIN to achieve this?

  A. SAP_SYSREC_ALL

  B. SAP_SOLAR02_ALL

  C. SAP_SM_ADMIN_COMPONENT_ALL

  D. SAP_SYSTEM_REPOSITORY_ALL

  Correct Answer: D

• Question 16:

  You need to replicate data from an SAP ERP production system to SAP HANA. Where does SAP recommend that you install the productive SAP Landscape Transformation (SLT) instance?

  A. With the SAP Solution Manager system

  B. On the SAP HANA server

  C. On a dedicated server

  D. With the SAP ERP system

  Correct Answer: C

• Question 17:

  The log volume is full and the SAP HANA database does not accept any new requests. How can you solve this problem and bring the SAP HANA database online?

  A. Delete older log files from the log volume before the last successful database backup.

  B. Set the log_mode parameter to overwrite in global.ini.

  C. Run "Delete older backups" in the Backup Catalog.

  D. Move the log files to another volume and create a symbolic link to the new folder.

  Correct Answer: D

• Question 18:

  Which of the following SAP HANA tools is used to collect diagnostic information?

  A. landscapeHostConfiguration.py

  B. hdbnsutil

  C. hdbsql

  D. fullSystemInfoDump.py

  Correct Answer: D

• Question 19:

  Your SAP HANA usage scenario does not require SAP HANA XS.

  What do you have to consider before you remove the SAP HANA XS service from the configuration? (Choose three)

  A. All applications using the SAP HANA instance must be stopped.

  B. User adm is required to remove the SAP HANA XS service.

  C. A data backup must be taken after the SAP HANA XS service has been removed.

  D. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance.

  E. The user privileges for accessing SAP HANA XS must be revoked.

  Correct Answer: ACD

• Question 20:

  Application users report that a query sometimes runs much slower than usual. You suspect that high system load is causing the slower query execution.

  Which of the following can you use to review overall system resource utilization at the time of query execution?

  A. SAP HANA Studio Administration Console->Performance LOAD

  B. DBA Cockpit (DBACOCKPIT) Current Status Alerts

  C. DBA Cockpit (DBACOCKPIT) Performance Expensive Statements

  D. SAP HANA Studio System Monitor Sessions

  Correct Answer: A