SAP C_HANATEC_12 Online Practice Questions and Exam Preparation

SAP C_HANATEC_12 Online Questions & Answers

• Question 1:

  You want to analyze the root cause of a query that is performing poorly. What does SAP recommend that you use in the SAP HANA studio?

  A. The Database trace
  B. The expensive statement trace
  C. The Visualize plan functionality
  D. The prepare statement functionality
  C. The Visualize plan functionality

• Question 2:

  For which activities do you use the diagnosis mode of the SAP HANA studio? (Choose two.)

  A. To change the configuration files when the system is down.
  B. To analyze problems during database startup.
  C. To view memory usage during database startup.
  D. To view diagnosis files when the system is down.
  A. To change the configuration files when the system is down.
  C. To view memory usage during database startup.

• Question 3:

  Which of the following must be running to view SAP HANA Diagnosis Files if the SAP HANA database is offline?

  A. Sapstartsrv
  B. SMD Agent
  C. r3trans
  D. disp+work
  A. Sapstartsrv

• Question 4:

  Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?

  A. Point-in-time recovery
  B. Information model recovery
  C. Automatic backup of archiving log files scheduled within SAP HANA
  D. Incremental backup
  A. Point-in-time recovery

• Question 5:

  Which of the following steps allow you to create a test system (system A) based on a productive SAP HANA standalone system (system B)? (Choose two.)

  A. Copy the data and log volume files from system B to system A.
  B. Export the data from system B to a file share and import the data to system A.
  C. Copy a snapshot from system B to system A.
  D. Restore a complete database backup from system B to system A.
  A. Copy the data and log volume files from system B to system A.
  D. Restore a complete database backup from system B to system A.

• Question 6:

  You have SAP HANA and ABAP content that is exclusively used by ABAP for SAP HANA. You want to transport this content together. Which of the following options can you use for this transport? (Choose two.)

  A. Export and Import of the Delivery Unit (DU)
  B. SAP HANA Transport Container (SAP HTC)
  C. Enhanced Change and Transport System (CTS+)
  D. SAP HANA Application Lifecycle Manager (SAP HALM)
  B. SAP HANA Transport Container (SAP HTC)
  C. Enhanced Change and Transport System (CTS+)

• Question 7:

  What type of data is transferred between the SAP HANA database and end user clients?

  A. Application data
  B. Data models
  C. Configuration models
  D. Configuration data
  A. Application data

• Question 8:

  Which of the following must you do in the SAP HANA studio to be able to use the Change and Transport System (CTS)? (Choose two.)

  A. Use a user who is authorized to attach SAP HANA content to transport requests.
  B. Create a delivery unit that contains all of the information models.
  C. Configure the connection to the CTS in the preferences.
  D. Create the HTTP connection CTSDEPLOY.
  A. Use a user who is authorized to attach SAP HANA content to transport requests.
  C. Configure the connection to the CTS in the preferences.

• Question 9:

  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. A data backup must be taken after the SAP HANA XS service has been removed.
  C. User adm is required to remove the SAP HANA XS service.
  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.
  A. All applications using the SAP HANA instance must be stopped.
  B. 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.

• Question 10:

  Which of the following are valid assignment sequences (assigning from the left to the right) of authorizations? (Choose two.)

  A. Role ? User ? Privilege
  B. Privilege ? Role ? User
  C. Role ? Privilege ? User
  D. Role ? Role ? User
  B. Privilege ? Role ? User
  D. Role ? Role ? User