You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

• A.The hierarchy must be a parent-child hierarchy.
• B.The hierarchy must be a shared hierarchy.
• C.The hierarchy must be exposed by a calculation view of type CUBE with star join.
• D.The hierarchy must be a local hierarchy.

Comment: *

Name: *

Email: *

Verification: *

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

• A.Multiple blocks can only be defined within a single calculation view.
• B.The block must only have one start node.
• C.Only one block can be defined across a stack of calculation views.
• D.The block must start with a node that defines a table as a data source.

Comment: *

Name: *

Email: *

Verification: *

In a calculation view, what is the purpose of a variable?

• A.To break up complex SQL into smaller steps
• B.To provide a dynamic value in a calculated column
• C.To pass values between procedures and calculation views
• D.To filter an attribute at runtime based on a user input

Comment: *

Name: *

Email: *

Verification: *

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

• A.Usage statistics of the calculation view
• B.Joins that are defined on calculated columns
• C.Expected memory consumption
• D.Information about join cardinality

Comment: *

Name: *

Email: *

Verification: *

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

• A.Select Data Preview for the calculation view.
• B.Set the HIDE property for columns NOT required.
• C.Select and deselect columns from the output mapping.
• D.Write and execute a custom SQL query in the SQL Console.

Comment: *

Name: *

Email: *

Verification: *