Where in a calculation view can you add a Graph node?
Please choose the correct answer.
Response:

• A.Always as the bottom (leaf) node
• B.Anywhere from the bottom (leaf) node to the default node
• C.Only as the top node

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 from the screen shot?

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

Comment: *

Name: *

Email: *

Verification: *

What can you discover using Data Lineage?
Please choose the correct answer.
Response:

• A.Underlying calculation views and tables
• B.Access statistics
• C.Data changes since last refresh
• D.Frequency of load

Comment: *

Name: *

Email: *

Verification: *

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

• A.Implement pruning rules.
• B.Limit the number of joined columns.
• C.Use an inner join.
• D.Specify the join cardinality.

Comment: *

Name: *

Email: *

Verification: *

Why do you use parameter mapping in a calculation view? Note:There are 2 correct answers to this question.

• A.To push down filters to the lowest level calculation views
• B.To convert the data types of input parameters
• C.To enable an input parameter in a calculation view
• D.To pass variable values to external value help views

Comment: *

Name: *

Email: *

Verification: *