SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 161:

  What engine executes the spatial queries? Please choose the correct answer. Response:

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

• Question 162:

  You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year.

  How can you achieve this?

  A. Use a calculated attribute.
  B. Use a calculated measure.
  C. Use a variable.
  D. Use a CE function.
  B. Use a calculated measure.
  D. Use a CE function.

• Question 163:

  In which schema does SAP HANA store an activated graphical calculation view? Please choose the correct answer. Response:

  A. _SYS_BIC
  B. SYS
  C. _SYS_BI
  D. SYSTEM
  A. _SYS_BIC

• Question 164:

  What must be installed for PAL to work? Please choose the correct answer. Response:

  A. SAP HANA AFM
  B. SAP HANA AFL
  C. SAP HANA BFL
  D. SAP HANA SINA
  B. SAP HANA AFL

• Question 165:

  Which spatial data formats can you import into SAP HANA? There are 2 correct answers to this question. Response:

  A. ESRI shapefiles
  B. Geo JSON
  C. Scalable Vector Graphic (SVG)
  D. Well Known Text (W KT)
  A. ESRI shapefiles
  D. Well Known Text (W KT)

• Question 166:

  Which business intelligence tools use BICS connectivity to SAP HANA? There are 2 correct answers to this question. Response:

  A. SAP BusinessObjects Design Studio
  B. Microsoft Excel
  C. SAP Lumira
  D. SAP BusinessObjects Analysis, edition for Microsoft Office
  A. SAP BusinessObjects Design Studio
  D. SAP BusinessObjects Analysis, edition for Microsoft Office

• Question 167:

  A traditional cube is represented by which SAP HANA view type? There are 2 correct answers to this question. Response:

  A. Attribute view
  B. Calculation view of type cube with star join
  C. Calculation view of type dimension
  D. Analytic view
  B. Calculation view of type cube with star join
  D. Analytic view

• Question 168:

  You modify an existing view. How can you determine which models are affected by this change?

  A. Use the audit trail.
  B. Use the History feature for the changed model.
  C. Use the "Where-Used List" feature for the changed model.
  D. Use the "Auto Documentation" to compare the object version of the changed model.
  C. Use the "Where-Used List" feature for the changed model.

• Question 169:

  What can you use to limit users to see only 2016 data? There are 2 correct answers to this question. Response:

  A. A view with a filter
  B. A SQL analytic privilege
  C. An object privilege
  D. A view with a restricted column
  A. A view with a filter
  B. A SQL analytic privilege

• Question 170:

  You want to aggregate the grand total sales amount into 1 currency.

  In which of the following cases would you select the Calculate Before Aggregation check- box? (Choose two)

  A. When an aggregate table by country contains sales values in 3 different currencies
  B. When a line item table contains sales values of 2 different currencies
  C. When a line item table contains sales values in 1 currency
  D. When an aggregate table by country contains sales values in 1 currency
  A. When an aggregate table by country contains sales values in 3 different currencies
  B. When a line item table contains sales values of 2 different currencies