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.2
• B.5
• C.6
• D.9

Comment: *

Name: *

Email: *

Verification: *

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.

• A.Join cardinality is set :1.
• B.Integrity constraint is set to RIGHT.
• C.The Country column is requested.
• D.The Keep flag is activated for the Customer column.

Comment: *

Name: *

Email: *

Verification: *

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud. Why should you switch calculated column expression language from column engine to SQL?

• A.To define limits for query unfolding
• B.Column engine language is not supported.
• C.To benefit from additional SQL optimizations
• D.Incorrect aggregations may be generated

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Using the table in the diagram, you need to create a CUBE calculation view. What is the simplest approach to create the output shown in the screenshot?

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

Comment: *

Name: *

Email: *

Verification: *