Question 1

Why would you use the Transparent Filter property in a calculation view?

ATo avoid columns being unnecessarily used in an aggregation

BTo include columns that are NOT requested by a query

CTo apply filters that are hidden from the end user

DTo allow filter push-down in stacked calculation views

Answer : D

Question 2

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

AAssign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type

BEnable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view

CEnable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Build the conversion rule

DAssign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column

Answer : A

Question 3

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it.What do you observe in the SAP HANA database container?

AThe build fails and the table is dropped.

BThe build fails and the table is not dropped.

CThe build is successful and the data preview returns expected data.

DThe build is successful but the data preview returns an error message.

Answer : C

Question 4

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option?Note: There are 2 correct answers to this question.

ATo ensure that the join execution only uses the join columns requested in the query

BTo ensure that the aggregation always happens after the join execution

CTo force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

DTo allow data analysis at different levels of granularity with the same calculation view

Answer : A, D

Question 5

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.When you preview calculation view A, what data do you see?

AUS for P1 and P2, and GE for P2

BUS for P1 and GE for P1

CUS for P1

DUS for P1 and P2, and GE for P1 and P2