SAP Certified Application Associate - SAP HANA 2.0 (SPS05)

QUESTION NO: 1
Which type of join supports a temporal condition in a calculation view?

A. Text join B. Inner join C. Referential join D. Left outer join

Correct Answer: B

QUESTION NO: 2
Why does query performance decrease when the data volume of the delta storage is large?
Note: There are 2 correct answers to this question.

A. The data is stored in the warm tier. B. The data is NOT sorted. C. The data is unstructured. D. The data is uncompressed.

Correct Answer: B,D

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

A. Vertical disaggregation B. Vertical aggregation C. Horizontal disaggregation D. Horizontal aggregation

Correct Answer: D

QUESTION NO: 4
What can you use SAP HANA smart data access for?
Note: There are 2 correct answers to this question.

A. To load and harmonize data from disparate sources B. To expose data from remote tables C. To replicate remote data sources D. To push down queries to data sources

Correct Answer: B,D

QUESTION NO: 5
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 force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query. B. To improve execution time under specific query conditions. C. To allow data analysis at different levels of granularity with the same calculation view. D. To ensure that the join execution only uses the join columns requested in the query.

Correct Answer: C,D

QUESTION NO: 6
Why do you build a calculation view of type SQL Access only?

A. To enable SQL access to your hierarchies B. To provide a high-performance model when only attributes are required C. To provide a data source that can only be consumed by a function or procedure D. To provide a data source that is only consumed by other calculation views

Correct Answer: D

QUESTION NO: 7
In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view.
Afterward, you perform the following build operations:
*Build the dimension calculation view as a single object.
*Build the entire SAP HANA database module. What is the outcome of the build operations?

A. The first build is successful.
The second build is successful. B. The first build fails.
The second build fails. C. The first build is successful.
The second build fails. D. The first build fails.
The second build is successful.

Correct Answer: A

QUESTION NO: 8
What does SAP HANA provide to support native application development
Note: There are 3 correct answers.

A. Built- in application server B. Choice of deployment to cloud or on-premise C. Multiple development languages D. Embedded SAP Business Warehouse(BW) E. Project management tools

Correct Answer: A,B,C

QUESTION NO: 9
In a calculation view, what is the purpose of a variable?

A. To provide a dynamic value in a calculated column B. To break up complex SQL into smaller steps C. To pass values between procedures and calculation views D. To provide a run-time attribute filter based on a user input

Correct Answer: B,D

SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C-HANAIMP-17 Exam Questions