SAP SAP Certifications C_HANAIMP_12 Questions & Answers

• Question 1:

  Which tab in SAP HANA studio shows validation check errors? Please choose the correct answer. Response:

  A. Properties

  B. History

  C. Problems

  D. Job Log

  Correct Answer: D

• Question 2:

  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

  Correct Answer: D

• Question 3:

  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

  Correct Answer: B

• Question 4:

  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

  Correct Answer: C

• Question 5:

  In which SAP HANA solution do you eliminate stored data, like year-todate figures? Please choose the

  correct answer.

  Response:

  A. SAP S/4HANA

  B. SAP BW on SAP HANA

  C. SAP HANA Enterprise Cloud

  D. SAP CRM on SAP HANA

  Correct Answer: A

• Question 6:

  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

  Correct Answer: BC

• Question 7:

  You created a user-defined function with the INVOKER security option. Which user's authorizations are

  checked when the function is executed? Please choose the correct answer.

  Response:

  A. The user calling the function

  B. The SYS REPO user

  C. The owner of the function

  D. The SYSTEM user

  Correct Answer: A

• Question 8:

  You are writing a mobile application for the World Series. You have details about all the baseball players

  and the baseball scores for all the previous matches.

  How do you use the data of the player information and the scores? Please choose the correct answer.

  Response:

  A. Both the player information and the scores are used as transactional data.

  B. The player information is used as master data, and the scores are used as transactional data.

  C. Both the player information and the scores are used as master data.

  D. The player information is used as transactional data, and the scores are used as master data.

  Correct Answer: B

• Question 9:

  Which of the following ways of publishing SAP HANA information model content could require some

  JavaScript knowledge?

  There are 2 correct answers to this question.

  Response:

  A. Creating business intelligence content with SAP BusinessObjects Design Studio

  B. Creating a composite provider in SAP BW

  C. Creating a REST web service in the SAP HANA XS engine

  D. Creating a report in SAP Crystal Reports for Enterprise

  Correct Answer: AC

• Question 10:

  Where can you create a filter expression? Please choose the correct answer. Response:

  A. In an aggregation node

  B. In a projection node

  C. In a data foundation node

  D. In the semantics node

  Correct Answer: B