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

Question 1

You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?
Note: There are 2 correct answers .

A. The hierarchy must be a local hierarchy. B. The hierarchy must be defined in a calculation view of type SQL ACCESSONLY. C. The hierarchy must be a shared hierarchy. D. The hierarchy must be exposed by a calculation view of type CUBE with star join.

Discussion 0

Correct Answer: C,D Vote an answer

Question 2

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. Partition large tables B. Implement union pruning C. Limit the number of stacked calculation views D. Avoid aggregating data early in the dataflow

Discussion 0

Correct Answer: A,C Vote an answer

Question 3

How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

A. Call the SAP-provided PAL decision tree procedure from the table function B. Build a flow graph and call it from the table function using input parameters C. Copy and adapt the SQL code generated by a flow graph into the table function D. Use dynamic SQL in the table function to generate the SQL code

Discussion 0

Correct Answer: B,C Vote an answer

Question 4

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 Source A has no records B. When the query requests only the PRODUCT_ID C. When the query requests PRODUCT_GROUP and PRODUCT_ID D. When the query requests PRODUCT_GROUP

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

Which of the following are usually no longer required in the architecture of SAPS/4HANA? Note: There are 2 correct answers to this question.

A. ABAP CDS B. Indexes C. Aggregates D. Synonyms

Discussion 0

Correct Answer: C,D Vote an answer

Question 6

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

Discussion 0

Correct Answer: B Vote an answer

Question 7

In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

A. You have a dedicated table lo generate the lists of help values for an input parameter. B. You have a large column store table that is consumed in a view with a variable on COUNTRY column. C. Your stacked model consists of multiple calculation views. D. You have a large row store table that is consumed in a view with a variable on COUNTRY column.

Discussion 0

Correct Answer: B Vote an answer

Question 8

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

A. SQL view B. Procedure C. Table function D. Scalar function

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

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