SAP Certified Application Associate - SAP HANA 2.0 (SPS05)

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. A

B. C

C. B

D. D

Correct Answer: D

Question 2

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. The HDB module references a user-provided service that does not exist.

B. The project is not assigned to a space.

C. You have assigned the project to a space that you do not have developer authorizations for.

D. You have not built the project.

Correct Answer: A,C

Question 3

You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build of the table function fails.
Which of the following could be a valid reason?

A. Your function includes a TRUNCATE statement

B. You did NOT define a valid table type.

C. You did not define at least one input parameter.

D. Your function refers to a scalar function.

Correct Answer: A

Question 4

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 5

What does a graph neighborhood search reveal?

A. Shortest path between vertices

B. Vertices that are closely connected

C. Vertices that contain the same attributes

D. Edges that contain the same attributes

Correct Answer: B

Question 6

Which types of data are used to represent spatial information?
Note: There are 2correct answers to this question.

A. Graph data

B. Column data

C. Vector data

D. Raster data

Correct Answer: C,D

Question 7

Which is the correct syntax when you refer to an input parameter in a calculation view expression?

A. :Choose_Country

B. $$Choose_Country$S

C. ..Choose_Country"

D. @Choose_Country

Correct Answer: B

Question 8

You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?

A. Define a projection node as the end of the parallelization block.

B. Define a union node as the start of the parallelization block.

C. Define a source column as partitioning value in the start node of the parallelization block.

D. Assign tables as the only data sources in the nodes that start the parallelization block.

Correct Answer: D

Question 9

Why do you build a calculation view of type SQL Access only?

A. To provide a data source that can only be consumed by a function or procedure

B. To provide a data source that is only consumed by other calculation views

C. To provide a high-performance model when only attributes are required

D. To enable SQL access to your hierarchies

Correct Answer: B

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

Latest Update

Useful Links

Contact Us