SAP Certified Application Associate - SAP HANA 2.0 (SPS03)

Question 1

How could you improve the performance of joins in cube calculation views? Note: these are 2 correct answers to this question.

A. Join on calculated columns

B. Avoid the use of referential joins

C. Reduce the number of columns used in the join

D. Specify the cardinally of the join

Correct Answer: C,D

Question 2

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables Dimension calculation view provide the attributes. What is the correct approach?

A. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.

B. Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use a join node to join the dimensions to the fact table.

C. Combine the transaction tables using a join node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.

D. Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use an aggregation node to join the dimensions to the fact table.

Correct Answer: C

Question 3

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

A. Analytic privileges

B. Synonym

C. Container

D. Role

Correct Answer: B

Question 4

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. Show lineage

B. Where used

C. Impact analysis

D. Database explorer

Correct Answer: A

Question 5

You deleted the design-time fi e of a calculation view in your HOB module.
Which of the following is the optimal way to ensure that the corresponding runtime object is also removed from the database?

A. Build the folder that contained the deleted design-time file.

B. Run a DELETE statement in an SOL console connected to the HDIcontainer.

C. Build the project that contained the deleted design-time file.

D. Delete the folder that contained the deleted design-time file .

Correct Answer: A

Question 6

You are a data analysis working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view? 2 correct

A. To provide partial value such as #3434 3#34##

B. To hide individual patients in groups of similar records

C. To add noise to the data to hide the actual values

D. To restrict data access for specific users or roles

Correct Answer: B,C

SAP Certified Application Associate - SAP HANA 2.0 (SPS03) - C_HANAIMP_15 Exam Practice Test

Latest Update

Useful Links

Contact Us