C-HANAIMP-16 by SAP Actual Free Exam Questions And Answers

Question 1

You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view. Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

A. Auto-map byname

B. Database Explorer

C. Where used

D. Show lineage

Discussion 0

Correct Answer: D Vote an answer

Question 2

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view?

A. SELECT or Privileges and Analytic Privileges on both views

B. Analytic Privileges and SELECT privileges on the CUBE Calculation view

C. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view

D. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view

Discussion 0

Correct Answer: D Vote an answer

Question 3

You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build of the table function fails.
Which of the following could be a valid reason?

A. Your function includes a TRUNCATE statement

B. You did not define at least one input parameter.

C. You did NOT define a valid table type.

D. Your function refers to a scalar function.

Discussion 0

Correct Answer: A Vote an answer

Question 4

You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect?
Note: There are 2 correct answers to this question.

A. When Source A has no records

B. When the query requests PRODUCT_GROUP and PRODUCT_ID

C. When the query requests only the PRODUCT_ID

D. When the query requests PRODUCT_GROUP

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

Your calculation view consumes one data source which includes the following columns :
SALES_ORDER_ID, PRODUCT_ID, QUANTITY & PRICE.
In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.
In which type of node do you define the calculation to display the correct result?

A. Projection

B. Union

C. Join

D. Aggregation

Discussion 0

Correct Answer: A Vote an answer

Question 6

When modeling in the Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

A. Alias

B. Virtual Table

C. Synonym

D. Association

Discussion 0

Correct Answer: C Vote an answer

Question 7

Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

A. They introduce potential security risk.

B. They call multiple processing engines

C. They can harm SQL optimization.

D. NOT all reporting tools can consume the results.

Discussion 0

Correct Answer: A Vote an answer

Question 8

How can you optimize performance when writing SQL for use with calculation views?
Note: There are 2 correct answers to this question.

A. Control the flow logic using IF-THEN-ELSE conditions

B. Use declarative language instead of cursors

C. Increase parallelization by using variables to break up statements

D. Use calculation engine (CE) functions instead of plain SQL

Discussion 0

Correct Answer: B,C Vote an answer

SAP Certified Application Associate - SAP HANA 2.0 (SPS04) - C-HANAIMP-16 Exam Practice Test

Contact Us

Useful Links

Latest Updated