SAP C_HANATEC_12 Online Practice Questions and Exam Preparation

SAP C_HANATEC_12 Online Questions & Answers

• Question 101:

  Which user must have SELECT privilege with the grant option on the data schema?

  A. _SYS_BIC
  B. _SYS_REPO
  C. SYSTEM
  D. ADM
  B. _SYS_REPO

• Question 102:

  You are replicating data in real-time from a source system to SAP HANA using System Landscape Transformation (SLT). The source system had to be restored using a point-in-time recovery to an earlier point in time. The systems are now out of sync.

  How can you synchronize the systems again?

  A. Select "Suspend" and "Resume" in the Data Provisioning dialog
  B. Restart the master job using transaction LTR in the SLT system
  C. Run the hdbnsutil program on the command line
  D. Select "Stop Replication" and "Replicate" in the Data Provisioning dialog
  D. Select "Stop Replication" and "Replicate" in the Data Provisioning dialog

• Question 103:

  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 104:

  Which of the following configuration files contains the backup locations of log and data files?

  A. attributes.ini
  B. indexserver.ini
  C. localclient.ini
  D. global.ini
  D. global.ini

• Question 105:

  Which of the following can be monitored in SAP Solution Manager system monitoring? (Choose three.)

  A. Expensive SQL statements
  B. Availability of SAP HANA services
  C. Alert status of SAP HANA internal alerting
  D. User-specific traces
  E. Host level monitoring
  B. Availability of SAP HANA services
  C. Alert status of SAP HANA internal alerting
  D. User-specific traces

• Question 106:

  Which of the following files should be considered in your SAP HANA backup strategy? (Choose three.)

  A. Dump files
  B. Export and import files
  C. Data and log files
  D. Kernel files
  E. Configuration files
  C. Data and log files
  D. Kernel files
  E. Configuration files

• Question 107:

  You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor. Which of the following privileges do you need to assign to that role? (Choose two.)

  A. SQL privilege SELECT for the SQL object SYS_STATISTICS
  B. System privilege CONTENT_ADMIN
  C. System privilege SERVICE_ADMIN
  D. System privilege DATA_ADMIN
  A. SQL privilege SELECT for the SQL object SYS_STATISTICS
  D. System privilege DATA_ADMIN

• Question 108:

  You created an information model in the SAP HANA studio and activated it successfully. When you execute the data preview you get an error message indicating missing privileges. Which of the following could solve the problem?

  A. GRANT SELECT ON SCHEMA TO _SYS_BIC
  B. GRANT SELECT ON SCHEMA TO _SYS_BI WITH GRANT OPTION
  C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANTOPTION
  D. GRANT CREATE ANY ON SCHEMA TO _SYS_REPO
  C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANTOPTION

• Question 109:

  A backup catalog became unusable.

  What can you do to recover existing backups?

  A. Create a new data backup.
  B. Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag.
  C. In SAP HANA studio Backup Editor Display all backups select REFRESH.
  D. Use a third party backup tool to recover the backups.
  B. Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag.

• Question 110:

  Which of the following commands stops the SAP HANA database?

  A. HDB -stop
  B. stop HDB
  C. stopsap hdb
  D. HDB stop
  D. HDB stop