SAP Certified Application Associate - SAP HANA 2.0 (SPS04) - C-HANAIMP-16 FREE EXAM DUMPS QUESTIONS & ANSWERS]

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

Discussion 0

Correct Answer: A,B Vote an answer

Question 2

Why might you use SAP HANA Graph with text analysis?

A. To uncover the dependencies between parts of speech B. To highlight similarities between documents using hierarchies C. To illustrate multi-point relationships between text entities D. To provide a visual method to build a custom text analysis

Discussion 0

Correct Answer: D Vote an answer

Question 3

You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameter of the calculation view B is not proposed to you as a source parameter.
What might be the reason for this?

A. You selected the wrong parameter mapping TYPE. B. The names of the input parameters do not match. C. You already mapped the input parameters in another calculation view. D. Your source calculation view is of the type SQL Access Only.

Discussion 0

Correct Answer: C Vote an answer

Question 4

Why do you use parameter mapping in a calculation view?
Note: There are 2 correct answers to this question.

A. To push down filters to the lowest level calculation views B. To convert the data types of input parameters C. To pass variable values to external value help views D. To enable an input parameter in a calculation view

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

When modeling in the Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

A. Virtual Table B. Synonym C. Alias D. Association

Discussion 0

Correct Answer: B Vote an answer

Question 6

You have a calculation view which includes nodes as shown in the graphic. You decide to select the "Ignore Multiple Output for Filters" check box on Projection Node 3. What might the effects of this be?
Note: There are 2 correct answers to this question.

A. Decreased performance B. Increased performance C. The view will return the profit calculation for only the US D. A change to the data that is returned by the view

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

Why do you use the debug query mode in a calculation view?

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

Discussion 0

Correct Answer: B Vote an answer

Question 8

Why do you create a multi store table?

A. To have a table that combines the characteristics of row and column stores B. To improve read performance when accessed by simultaneous applications C. To evenly distribute the data across all available server nodes D. To have the opt on to partition the table across different storage tiers

Discussion 0

Correct Answer: D Vote an answer