SAP Certified Application Associate - SAP HANA 2.0 (SPS03) (C-HANAIMP-15) Free Practice Test

Question 1

Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

A. D

B. A

C. B

D. C

Correct Answer: D

Question 2

Why do we support SOL development in SAP HANA data modeling projects?

A. To provide access to your data model to additional clients tools.

B. To make changes to the runtime objects of your calculation view with SQL.

C. As an alternative to developing calculation views when high performance is essential.

D. To support development of custom logic within calculation views.

Correct Answer: D

Question 3

Which of the following allows data replication?

A. SAP HANA streaming analytics

B. SAP HANA smart data integration

C. SAP HANA smart data quality

D. SAP HANA smart data access

Correct Answer: B

Question 4

You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic.
The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE * QUANTITY.
How do you ensure accurate results, regardless of the column in the query output?

A. Set STATE as an aggregated column.

B. Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL

C. Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL

D. Set the Transparent Filter property for STATE

Correct Answer: C

Question 5

What is the role of core modeling in SAP HANA?
There are 2 correct answers to this question.
Response:

A. To simplify applications

B. To develop more secure user authentication

C. To develop reuseable data processing logic in the database

D. To push data-intensive processing up to the application to obtain the best performance

Correct Answer: A,C

Question 6

What do you use a hierarchy function for? Note:There are 3 correct answers.

A. Identify hierarchy nodes that have no parent

B. Describe the relationship between nodes using attributes

C. Count the number of siblings for each hierarchy node

D. Calculate distance between root and each hierarchy node

E. Determine the shortest path between each pair of nodes

Correct Answer: B,C,D

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA 2.0 (SPS03) (C-HANAIMP-15) Free Practice Test