SAP Certified Application Associate - SAP HANA 2.0 (SPS05)

Question 1

What type of data is relevant for SAP HANA Graph modeling?

A. Hierarchical data

B. Timeseries

C. Forecast

D. Highly-networked

Correct Answer: D

Question 2

You combine two tables in a join using multiple columns in each table. Why do you enable the dynamic join option?
Note: There are 2 correct answers to this question.

A. To improve execution time under specific query conditions.

B. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query.

C. To ensure that the join execution only uses the join columns requested in the query.

D. To allow data analysis at different levels of granularity with the same calculation view.

Correct Answer: C,D

Question 3

What can you extract using the standard text analysis configuration: Voice of the Customer? Note: There are 2 correct answers to this question.

A. Requests

B. Suggestions

C. Sentiments

D. Recommendations

Correct Answer: A,C

Question 4

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

A. Run a DELETE statement in an SQL console connected to the HDI container.

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

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

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

Correct Answer: B,D

Question 5

In a calculation view, what is the purpose of a variable?

A. To pass values between procedures and calculation views

B. To break up complex SQL into smaller steps

C. To provide a run-time attribute filter based on a user input

D. To provide a dynamic value in a calculated column

Correct Answer: B,C

Question 6

Which type of join supports a temporal condition in a calculation view?

A. Inner join

B. Referential join

C. Left outer join

D. Text join

Correct Answer: A

Question 7

Why do we use Git when modeling calculation views?

A. Develop conceptual prototypes

B. Enable collaboration between developers

C. Control specifically object versioning

D. Provide access to external schemas

Correct Answer: C

Question 8

In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?

A. Horizontal disaggregation

B. Vertical aggregation

C. Horizontal aggregation

D. Vertical disaggregation

Correct Answer: C

Question 9

You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?
Note: There are 2 correct answers .

A. The hierarchy must be exposed by a calculation view of type CUBE with star join.

B. The hierarchy must be defined in a calculation view of type SQL ACCESSONLY.

C. The hierarchy must be a shared hierarchy.

D. The hierarchy must be a local hierarchy.

Correct Answer: A,C

SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C_HANAIMP_17 Exam Practice Test

Latest Update

Useful Links

Contact Us