SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C-HANAIMP-18 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What are some best practices when developing calculation views?Note: There are 2 correct answers to this question.

A. Include all data flow logic within one calculation view. B. Model star schemas using a sequence of join nodes. C. Aggregate at the lowest possible node. D. Avoid defining joins on calculated columns.

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

Which tool generates and executes the SQL for a specific node of your calculation view?

A. Database explorer B. Debug Query mode C. Explain plan D. SQL analyzer

Discussion 0

Correct Answer: B Vote an answer

Question 3

Why would you create SQL in calculation views?

A. To provide an alternative to graphical modeling B. To enable write capabilities C. To fine-tune performance D. To implement custom logic

Discussion 0

Correct Answer: D Vote an answer

Question 4

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node.How many rows are in the output of your query?

A. 6 B. 9 C. 2 D. 5

Discussion 0

Correct Answer: B Vote an answer

Question 5

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 star join node in a calculation view of type cube with star join.Use the same star join node to connect 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 with star join.Use a star join node to join the dimensions to the fact table. 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: C Vote an answer

Question 6

What are the key steps to implement currency conversion in a calculation view?

A. Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type B. Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Build the conversion rule C. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view D. Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column

Discussion 0

Correct Answer: A Vote an answer

Question 7

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

A. SQL compilation time increases B. Results are read from static cache C. Query processing time improves D. Count-distinct results are incorrect

Discussion 0

Correct Answer: A,B Vote an answer

Question 8

Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note:
There are 2 correct answers to this question.

A. Limit the number of joined columns B. Use an inner join C. Define join direction in a full outer join D. Specify the join cardinality

Discussion 0

Correct Answer: A,D Vote an answer

Question 9

In a calculation view, why would you implement an SQL expression?Note: There are 3 correct answers to this question.

A. To convert currencies B. To generate a restricted column C. To generate a calculated column D. To define a filter E. To generate hierarchies

Discussion 0

Correct Answer: B,C,D Vote an answer