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

• A.Row table
• B.Table function
• C.Procedure
• D.Scalar function

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.The Country column is requested.
• B.Join cardinality is set :1.
• C.The Keep flag is activated for the Customer column.
• D.Integrity constraint is set to RIGHT.

Comment: *

Name: *

Email: *

Verification: *

In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?

• A.Scalar function
• B.Table function
• C.Anonymous block
• D.Procedure

Comment: *

Name: *

Email: *

Verification: *

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note:
There are 2 correct answers to this question.

• A.To remove a column that is also used as a Label column
• B.To ensure specific columns are NOT exposed to the reporting tool
• C.To avoid exposing sensitive columns when defining calculated columns
• D.To prevent passing columns in stacked calculation views

Comment: *

Name: *

Email: *

Verification: *

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. How do you ensure that each customer name appears only once in the results?

• A.Add an intersect node above the union node.
• B.Include an aggregation node above the union node.
• C.In the union node, map both source customer name columns to one target column.
• D.Define a restricted column in a union node.

Comment: *

Name: *

Email: *

Verification: *