SAP Certified Application Associate - SAP HANA 2.0 (SPS04)

QUESTION NO: 1
You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
Note: There are 2 correct answers to this question.

A. To hide individual patients in groups of similar records B. To add noise to the data to hide the actual values C. To restrict data access for specific users or roles D. To provide partial value such as #34343#34##

Correct Answer: A,B

QUESTION NO: 2
Why do you use the debug query mode in a calculation view?

A. To highlight potential performance issues at design-time B. To observe the generated SQL for each node C. To measure the overall run-time of the query D. To check which database engines will be invoked by each node

Correct Answer: B

QUESTION NO: 3
Why might you use the Keep Flag property in an aggregation node?

A. To retain the correct aggregation behavior in stacked views. B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query C. To cache the results of the aggregation node for drill-down D. To include columns that are NOT requested by a query but are essential for the correct result

Correct Answer: D

QUESTION NO: 4
Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question.

A. Implement pruning rules. B. Specify the join cardinality. C. Limit the number of joined columns. D. Use an inner join.

Correct Answer: B,C

QUESTION NO: 5
In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

A. CDS view B. Procedure C. Virtual Table D. Table function

Correct Answer: D

QUESTION NO: 6
After importing a project in the workspace of the Web IDE, you try to build the HDB module. The build fails.
What could be the reason?
Note: There are 2 correct answers.

A. You have assigned the project to a space that you do not have developer authorizations for. B. You have not built the project. C. The HDB module references a user-provided service that does not exist. D. The project is not assigned to a space.

Correct Answer: A,C

QUESTION NO: 7
When you create a full text index, why do you specify FAST_PREPROCESS OFF?

A. To prevent the creation of a fuzzy search index B. To enable a full linguistic search C. To avoid the generation of the term document matrix D. To generate text analysis results in multiple languages

Correct Answer: B

QUESTION NO: 8
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

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