SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 141:

  You created a user-defined function with a return type of BIGINT. What type of function have you created?

  Please choose the correct answer.

  Response:

  A. SQL function
  B. Table function
  C. Scalar function
  D. Window function
  C. Scalar function

• Question 142:

  What information can you find in the Explain Plan tool? There are 2 correct answers to this question. Response:

  A. The number of records returned in each step
  B. The execution engines used
  C. The list of operators
  D. The time taken for each step
  B. The execution engines used
  C. The list of operators

• Question 143:

  What does SAP recommend to improve performance of data models in SAP HANA?

  A. Move intensive calculations to the front-end application
  B. Perform calculation before aggregation
  C. Utilize as many different engines as possible
  D. Minimize data transfer between the engines
  D. Minimize data transfer between the engines

• Question 144:

  What phrase describes the main table area in the delta merge scenario? Please choose the correct answer. Response:

  A. Row store
  B. Unsorted inserts
  C. Write-optimized
  D. Read-optimized
  D. Read-optimized

• Question 145:

  You execute the performance validations for a calculation view. Which columns are checked by the 'Calculation in filter expression' rule?

  Please choose the correct answer.

  Response:

  A. Generated columns
  B. Restricted columns
  C. Numeric columns
  D. Aggregated columns
  D. Aggregated columns

• Question 146:

  Which SAP HANA studio function displays the views that will be affected when you rename an attribute view?

  Please choose the correct answer.

  Response:

  A. Neighbor
  B. Where-used list
  C. Properties
  D. Tables used
  B. Where-used list

• Question 147:

  What is an example of a selective data load using SAP Landscape Transformation?

  A. Selected data field values are randomized and loaded into SAP HANA.
  B. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
  C. Selected data for transformation is split into portions.
  D. Selected data for a range of years is loaded into SAP HANA.
  D. Selected data for a range of years is loaded into SAP HANA.

• Question 148:

  In which SAP HANA studio perspective do you find the Quick View tab options? Please choose the correct answer. Response:

  A. Developer perspective
  B. Modeler perspective
  C. Plan visualizer perspective
  D. Administration perspective
  B. Modeler perspective

• Question 149:

  You have a view with two tables, joined by a left outer join. If you redesign the view and accidently swap the two tables around, what should you do to the join? Please choose the correct answer. Response:

  A. Change the join to a referential join.
  B. Keep the left outer join.
  C. Change the join to a text join.
  D. Change the join to a right outer join.
  D. Change the join to a right outer join.

• Question 150:

  You have created several information models. A colleague of yours needs to be able to work on your information models.

  Which privileges do you give your colleague?

  A. Analytic privileges
  B. Package privileges
  C. Dynamic analytic privileges
  D. Object privileges
  B. Package privileges