SAP C_HANATEC_12 Online Practice Questions and Exam Preparation

SAP C_HANATEC_12 Online Questions & Answers

• Question 161:

  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. Run "Delete older backups" in the Backup Catalog.
  B. Set the log_mode parameter to overwrite in global.ini.
  C. Move the log files to another volume and create a symbolic link to the new folder.
  D. Delete older log files from the log volume before the last successful database backup.
  C. Move the log files to another volume and create a symbolic link to the new folder.

• Question 162:

  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
  C. On a dedicated server

• Question 163:

  A customer complains about poor performance when they query a column table with 5 billion records. You suspect that this table is partially loaded into memory. Where can you to check the load status of this table? (Choose two.)

  A. On the Runtime Information tab of the table definition
  B. In the M_TABLES view
  C. In the M_TABLE_PERSISTENCE_LOCATIONS view
  D. In the M_CS_TABLES view
  A. On the Runtime Information tab of the table definition
  D. In the M_CS_TABLES view

• Question 164:

  Which of the following views allows an administrator to identify all the authorizations assigned to a user?

  A. EFFECTIVE_PRIVILEGES
  B. USERS
  C. GRANTED_ROLES
  D. GRANTED_PRIVILEGES
  A. EFFECTIVE_PRIVILEGES

• Question 165:

  Which of the following are benefits of using accelerators with SAP HANA? (Choose two.)

  A. They provide prebuilt customer-specific solutions.
  B. They eliminate the need for customization.
  C. They reduce the time required for implementation.
  D. They provide prebuilt business content.
  C. They reduce the time required for implementation.
  D. They provide prebuilt business content.

• Question 166:

  Which of the following are functions of the controller on the SAP Landscape Transformation (SLT) server? (Choose two.)

  A. Create repositories in the source system.
  B. Write data to the SAP HANA system using the DB connection.
  C. Schedule replication processes.
  D. Map database structures between SAP HANA and the source system.
  C. Schedule replication processes.
  D. Map database structures between SAP HANA and the source system.

• Question 167:

  Which of the following can you use to analyze an expensive SQL statement? (Choose two.)

  A. The hdbcons tool
  B. The plan explanation
  C. The plan visualizer
  D. The performance trace view
  B. The plan explanation
  C. The plan visualizer

• Question 168:

  Which of the following is a result of using SAP HANA as an application platform?

  A. Aggregates in data models are only materialized when required.
  B. Calculation-intensive logic is pushed down to the database.
  C. The need for indexes is eliminated.
  D. All database queries have a sub-second response time.
  B. Calculation-intensive logic is pushed down to the database.

• Question 169:

  Which of the following are benefits of implementing SAP HANA? (Choose three.)

  A. SAP HANA combines OLTP and OLAP in one system.
  B. SAP HANA replaces SAP BW.
  C. SAP HANA performs much faster than the standard SAP ERP.
  D. SAP HANA provides pre-configured BI Content.
  E. SAP HANA provides real-time analytics.
  A. SAP HANA combines OLTP and OLAP in one system.
  C. SAP HANA performs much faster than the standard SAP ERP.
  E. SAP HANA provides real-time analytics.

• Question 170:

  Which operating system commands show the SAP HANA processes? (Choose two.)

  A. HDB admin
  B. HDB version
  C. HDB info
  D. HDB proc
  C. HDB info
  D. HDB proc