C_HANAIMP_17 by SAP Actual Free Exam Q&As

Question 1

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. Use an inner join. B. Implement pruning rules. C. Limit the number of joined columns. D. Specify the join cardinality.

Discussion 0

Correct Answer: C,D Vote an answer

Question 2

What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container?

A. Database connection B. Function C. Wrapper D. Synonym

Discussion 0

Correct Answer: B Vote an answer

Question 3

Why do you implement Active / active read-enabled mode?

A. To enhance security for data access B. To provide offline access to data C. To improve query performance D. To synchronize query results with operational data

Discussion 0

Correct Answer: D Vote an answer

Question 4

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 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. B. 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. C. 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. D. 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.

Discussion 0

Correct Answer: A Vote an answer

Question 5

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. Embedded SAP Business Warehouse(BW) D. Project management tools E. Multiple development languages

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 6

What are the components of a graph workspace?
Note: There are 2 correct answers to this question.

A. Dimension B. Association C. Edge D. Vertex

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?

A. Full outer joins are restricted to one dimension in a star join node. B. Full outer joins CANNOT be mixed in the same star join node with other join types. C. Full outer joins require cardinality to beset. D. Full outer joins are NOT available in the star join node.

Discussion 0

Correct Answer: A Vote an answer

Question 8

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 9

Why do you create calculation views of data category DIMENSION with type TIME?

A. To add a temporal condition to a join to find matching records from two tables based on a date. B. To store historical version of attributes. C. To provide additional time-related navigation possibilities D. To provide the time intervals required by time-dependent parent-child hierarchies.

Discussion 0

Correct Answer: C Vote an answer

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