SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 31:

  If we change the transaction "Laura buys 10 apples" to "Laura buys 10 green apples," how would we store the color green?

  Please choose the correct answer.

  Response:

  A. Store green as a CDS view
  B. Store green as a spatial data type
  C. Store green as a measure
  D. Store green as an attribute
  D. Store green as an attribute

• Question 32:

  Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server?

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

• Question 33:

  Which of the following are required elements when you create any type of hierarchy in SAP HANA?

  A. A child node
  B. An analytic view
  C. A data foundation
  D. An attribute view
  C. A data foundation
  D. An attribute view

• Question 34:

  You want to restrict access to SAP HANA information models based on user groups. The models are accessed through an SAP BusinessObjects report. In which of the following can you implement these restrictions? (Choose two)

  A. The schema mapping
  B. The restricted measures
  C. The analytic privileges
  D. The universe
  C. The analytic privileges
  D. The universe

• Question 35:

  What SQL construct do you use to return multiple result sets from a single SQL statement? There are 2 correct answers to this question. Response:

  A. GROUPING SETS
  B. SELECT subquery
  C. JOIN
  D. UNION
  C. JOIN
  D. UNION

• Question 36:

  Which actions does refactoring typically use? There are 2 correct answers to this question. Response:

  A. Deleting
  B. Moving
  C. Renaming
  D. Transporting
  B. Moving
  C. Renaming

• Question 37:

  Which engine is used for calculation and aggregation based on star schema

  A. Join Engine
  B. Calculation Engine
  C. SQL Optimizer Engine
  D. OLAP Engine
  D. OLAP Engine

• Question 38:

  You have logs from a website. How do you show the total number of website visitors that used a mobile phone?

  There are 2 correct answers to this question.

  Response:

  A. Create a filter expression
  B. Create an action
  C. Create a rank column
  D. Create a restricted column
  A. Create a filter expression
  D. Create a restricted column

• Question 39:

  What is the advantage of reporting directly from column tables?

  A. It provides multi-language support
  B. It eliminates the need for additional modeling
  C. It shifts complex calculations and logic to SAP HANA
  D. It supports analytical privileges
  B. It eliminates the need for additional modeling

• Question 40:

  You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you execute the decision table.

  What do you have to use in the data foundation to achieve this? Please choose the correct answer.

  Response:

  A. A scripted calculation view
  B. A virtual table
  C. A dynamic join
  D. A table type
  D. A table type