SAP Certified Application Associate - SAP HANA 2.0 SPS06

Question 1

You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views all belong to the same project.Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

A. Activate the project -> Build the HDB module

B. Build the HDB module -> Build the project

C. Build the project -> Build the HDB module

D. Export the HDB module -> Export the project

Correct Answer: C

Question 2

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

A. Select and deselect columns from the output mapping.

B. Write and execute a custom SQL query in the SQL Console.

C. Select Data Preview for the calculation view.

D. Set the HIDE property for columns NOT required.

Correct Answer: B

Question 3

Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

A. Scalar function

B. Procedure

C. Row table

D. Table function

Correct Answer: C,D

Question 4

Why would you partition a table in an SAP HANA Cloud database?Note: There are 2 correct answers to this question.

A. To improve response time when multiple users access the same table

B. To improve data replication performance on large row tables

C. To improve query performance when accessing large column tables

D. To overcome the 2 billion record limit

Correct Answer: C,D

Question 5

After importing a project in the workspace of the SAP Web IDE, you execute a build at the HDB module level. The build fails.What could be the reason?Note: There are 2 correct answers to this question.

A. You have not built the project yet.

B. You have not defined the HDI build plug-in version.

C. Your HDB module references a user-provided service that does not exist.

D. You have not assigned the project to a space.

Correct Answer: C,D

Question 6

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

A. Avoid aggregating data early in the data flow.

B. Implement union pruning.

C. Partition large tables.

D. Limit the number of stacked calculation views.

Correct Answer: C,D

Question 7

What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

A. It CANNOT be mixed in the same star join node with other join types.

B. It must appear in the last DIMENSION in the star join node.

C. It is restricted to one DIMENSION in a star join node.

D. Only one column can be included in the join condition.

Correct Answer: B,C

Question 8

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 filter an attribute at run-time based on a user input

D. To provide a dynamic value in a calculated column

Correct Answer: C

Question 9

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.When you preview calculation view A, what data do you see?

A. US for P1 and GE for P1

B. US for P1 and P2, and GE for P2

C. US for P1 and P2, and GE for P1 and P2

D. US for P1

Correct Answer: D

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C-HANAIMP-18 Exam Practice Test

Latest Update

Useful Links

Contact Us