SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 21:

  You created a calculated column in an analytic view for a table containing the number of units ordered, the price per unit, and the number of units in stock.

  You get the wrong results in your results. What could be the problem? Please choose the correct answer.

  Response:

  A. You chose the SQL expression syntax
  B. You mistyped the calculated column expression
  C. You did NOT enable the currency conversion
  D. You did NOT enable calculate before aggregation
  D. You did NOT enable calculate before aggregation

• Question 22:

  Which can a level hierarchy do? Please choose the correct answer. Response:

  A. Be used for a bill of materials structure
  B. Enable drill-down in a value help list
  C. Show variable deepness in the data
  D. Have time-dependency
  B. Enable drill-down in a value help list

• Question 23:

  An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution. Which of the following could you check to resolve the error? (Choose two)

  A. The business layer
  B. The business view
  C. The Web Intelligence report variables
  D. The SAP HANA information model
  A. The business layer
  D. The SAP HANA information model

• Question 24:

  Which types of calculation views can you create? There are 2 correct answers to this question. Response:

  A. Derived
  B. Materialized
  C. Standard
  D. Time-based
  C. Standard
  D. Time-based

• Question 25:

  You need a business intelligence tool that is Microsoft Excel-based and can use parent-child hierarchies.

  Which tool do you use?

  Please choose the correct answer.

  Response:

  A. SAP BusinessObjects Web Intelligence
  B. SAP Lumira
  C. SAP BusinessObjects Analysis, edition for OLAP
  D. SAP BusinessObjects Design Studio
  A. SAP BusinessObjects Web Intelligence

• Question 26:

  In which View, client queries can be less optimized and could significantly be slower compare to other models

  A. Analytic
  B. Attribute
  C. Calculation (SQL)
  D. Calculation (CE Functions)
  C. Calculation (SQL)

• Question 27:

  Where can you deploy the column view of a decision table?

  A. In SAP Visual Intelligence
  B. In Microsoft Excel
  C. In calculation views
  D. In analytic views
  A. In SAP Visual Intelligence
  C. In calculation views

• Question 28:

  Of which SAP HANA process are the transaction manager and page manager a part? Please choose the correct answer. Response:

  A. SAP HANA XS server
  B. Name server
  C. Index server
  D. Statistics server
  C. Index server

• Question 29:

  A referential join gives the same results as which other join type? Please choose the correct answer. Response:

  A. Left outer join
  B. Spatial join
  C. Inner join
  D. Star join
  C. Inner join

• Question 30:

  What is normally used to build SAP HANA XS applications inside SAP HANA? There are 2 correct answers to this question. Response:

  A. JavaScript
  B. Java
  C. ABAP
  D. SAPUIS
  A. JavaScript
  D. SAPUIS