SAP C_HANATEC_12 Online Practice Questions and Exam Preparation

SAP C_HANATEC_12 Online Questions & Answers

• Question 21:

  Which of the following is an SQL privilege?

  A. EXPORT
  B. DEVELOPMENT
  C. SAVEPOINT ADMIN
  D. DROP
  D. DROP

• Question 22:

  Which of the following can performed in the SAP HANA lifecycle manager? (Choose three.)

  A. Copy an SAP HANA system.
  B. Uninstall an SAP HANA system
  C. Change the SAP HANA license type.
  D. Add an additional SAP HANA system.
  E. Rename an SAP HANA system.
  C. Change the SAP HANA license type.
  D. Add an additional SAP HANA system.
  E. Rename an SAP HANA system.

• Question 23:

  What information is presented when you check the license key?

  A. SAP HANA build number
  B. SAP HANA support package number
  C. SAP HANA edition type
  D. SAP HANA licensed memory amount
  D. SAP HANA licensed memory amount

• Question 24:

  Which of the following are advantages of using the SAP CO-PA accelerator? (Choose two.)

  A. Reduces reporting time.
  B. Eliminates the need for customization.
  C. Transforms data during the load step.
  D. Provides business configuration.
  A. Reduces reporting time.
  D. Provides business configuration.

• Question 25:

  You want to update a productive SAP HANA system to the next support package stack (SPS). What are the prerequisites? (Choose two.)

  A. You performed a backup of the system.
  B. You applied the new license key for the new SPS
  C. You planned a business downtime for the system.
  D. You prepared the data and log area in the file system
  E. You know the adm password.
  B. You applied the new license key for the new SPS
  D. You prepared the data and log area in the file system

• Question 26:

  Which tab in SAP HANA studio displays CPU load history data?

  A. Volumes
  B. Overview
  C. Performance
  D. Landscape
  C. Performance

• Question 27:

  Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system? (Choose two.)

  A. Choose:Data exports
  B. Log files
  C. Backup data files
  D. Runtime dump files
  A. Choose:Data exports
  D. Runtime dump files

• Question 28:

  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. DBA Cockpit (DBACOCKPIT) Performance Expensive Statements
  B. SAP HANA Studio Administration Console->Performance LOAD
  C. SAP HANA Studio System Monitor Sessions
  D. DBA Cockpit (DBACOCKPIT) Current Status Alerts
  B. SAP HANA Studio Administration Console->Performance LOAD

• Question 29:

  In which file do you configure the maximum size of the delta storage memory?

  A. preprocessor.ini
  B. executer.ini
  C. global.ini
  D. indexserver.ini
  D. indexserver.ini

• Question 30:

  You are reviewing the execution plan of an SQL statement. You want to find out which operators have been executed in parallel in the current plan and for how long each of them has been active. How can you accomplish this?

  A. Use Job Progress in the SAP HANA studio.
  B. Use EXPLAIN (graphically) in the DBA Cockpit.
  C. Use Performance Trace in HDB admin.
  D. Use the Plan Visualizer in the SAP HANA studio.
  D. Use the Plan Visualizer in the SAP HANA studio.