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
You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.
What is the correct approach?

A. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.
Use a star join node to join the dimensions to the fact table. B. Combine the transaction tables using a join node in a calculation view of type cube.
Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views. C. Combine the transaction tables using a star join node in a calculation view of type cube with star join.
Use a join node to join the dimensions to the fact table. D. Combine the transaction tables using a join node in a calculation view of type cube with star join.
Use a star join node to join the dimensions to the fact table.

Correct Answer: D

QUESTION NO: 3
A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018. What is the optimal way to do this?

A. Use an left outer join. B. Use a union node. C. Use a full outer join. D. Use an intersect node

Correct Answer: D

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

A. Assign tables as the only data sources in the nodes that start the parallelization block. B. Define a source column as partitioning value in the start node of the parallelization block. C. Define a union node as the start of the parallelization block. D. Define a projection node as the end of the parallelization block.

Correct Answer: A

QUESTION NO: 5
You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect?
Note: There are 2 correct answers to this question.

A. When the query requests PRODUCT_GROUP B. When the query requests PRODUCT_GROUP and PRODUCT_ID C. When Source A has no records D. When the query requests only the PRODUCT_ID

Correct Answer: A,C

QUESTION NO: 6
Which of the following allows data replication?

A. SAP HANA smart data integration B. SAP HANA smart data quality C. SAP HANA smart data access D. SAP HANA streaming analytics

Correct Answer: A

QUESTION NO: 7
Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output from the screen shot?

A. Create 3 calculated columns. B. Create a filter expression that uses an OR operator. C. Create a restricted column for each year. D. Implement a union node and map each year as a separate column.

Correct Answer: C

QUESTION NO: 8
Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

A. They can harm SQL optimization. B. They introduce potential security risk. C. They call multiple processing engines D. NOT all reporting tools can consume the results.

Correct Answer: B

QUESTION NO: 9
You have imported a new calculation view in a folder that contains a .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-related issue and the build fails.
What could be the reason? Note: There are 2 correct answers.

A. The imported calculation view and its data source have different namespaces. B. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table. C. The hdinamespace specifies "sub-folder": "append'', so calculation views can only be created in sub-folders. D. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.

Correct Answer: A,B

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