SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 81:

  Which of the following must you avoid to ensure your calculation view uses only the calculation engine?

  A. Combining SQL and CE Functions
  B. Reading from tables in the column store
  C. Reading from tables using SELECT statements
  D. Joins using SQL
  E. DO WHILE loops
  A. Combining SQL and CE Functions
  C. Reading from tables using SELECT statements
  D. Joins using SQL

• Question 82:

  What performance techniques should you implement to improve the performance of SAP HANA information views?

  There are 3 correct answers to this question.

  Response:

  A. Push down aggregations to SAP HANA.
  B. Perform calculation before aggregation in your analytic views.
  C. Minimize the transfer of data between the execution engines.
  D. Investigate partitioning of large tables.
  E. Apply filters as late as possible.
  A. Push down aggregations to SAP HANA.
  C. Minimize the transfer of data between the execution engines.
  D. Investigate partitioning of large tables.

• Question 83:

  During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters? (Choose two)

  A. In a query transformation in SAP BusinessObjects Data Services
  B. In a row generation transformation in SAP BusinessObjects Data Services
  C. In a SQL WHERE clause in SAP Landscape Transformation (SLT)
  D. In an ABAP code rule in SAP Landscape Transformation (SLT)
  A. In a query transformation in SAP BusinessObjects Data Services
  D. In an ABAP code rule in SAP Landscape Transformation (SLT)

• Question 84:

  Where can you set the default value for the SAP client for the entire calculation view? Please choose the correct answer. Response:

  A. In the join node of the calculation view
  B. In the Window menu of SAP HANA studio
  C. In the default node of the calculation view
  D. In the semantic layer of the calculation view
  D. In the semantic layer of the calculation view

• Question 85:

  When table replication is suspended, what does the SAP Landscape Transformation (SLT) server do?

  A. It prevents the RFC connection from reading the source system logging tables.
  B. It deletes the database triggers and the logging tables in the source system.
  C. It stops the RFC connection and deletes the target tables in SAP HANA.
  D. It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA.
  A. It prevents the RFC connection from reading the source system logging tables.

• Question 86:

  In which subfolder of the _SYS_BIC schema do you find activated information models? Please choose the correct answer. Response:

  A. Functions
  B. Column Views
  C. Procedures
  D. Views
  B. Column Views

• Question 87:

  What information can you find in the Administration Console? There are 2 correct answers to this question. Response:

  A. The trace and log files
  B. The list of operators
  C. The execution engines used
  D. The SQL Plan Cache
  A. The trace and log files
  D. The SQL Plan Cache

• Question 88:

  For what SQL keyword is the aggregation node the equivalent? Please choose the correct answer. Response:

  A. UNIQUE
  B. ORDER BY
  C. DISTINCT
  D. GROUP BY
  D. GROUP BY

• Question 89:

  Which are the recommended assignments in SAP HANA?

  There are 2 correct answers to this question.

  Response:

  A. Privileges to users
  B. Roles to roles
  C. Roles to privileges
  D. Roles to users
  B. Roles to roles
  D. Roles to users

• Question 90:

  Which deployment scenario can you use to accelerate reporting from an old SAP R/ 3 4.6C system? Please choose the correct answer. Response:

  A. SAP HANA as a sidecar solution
  B. SAP HANA multitenant database containers
  C. SAP HANA as a platform
  D. SAP HANA as a database
  A. SAP HANA as a sidecar solution