When is the first column store compression executed?

• A.When a delta merge is triggered
• B.When partitions are regenerated
• C.When the table is created
• D.When a backup is started

Comment: *

Name: *

Email: *

Verification: *

Which of the following techniques can you use to improve the performance of calculation views? Note:
There are 2 correct answers to this question.

• A.Implement union pruning.
• B.Partition large tables.
• C.Limit the number of stacked calculation views.
• D.Avoid aggregating data early in the data flow.

Comment: *

Name: *

Email: *

Verification: *

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 local hierarchy.
• B.The hierarchy must be a shared hierarchy.
• C.The hierarchy must be a parent-child hierarchy.
• D.The hierarchy must be exposed by a calculation view of type CUBE with star join.

Comment: *

Name: *

Email: *

Verification: *

What is a restricted measure?

• A.A measure that is filtered by one or more attribute values.
• B.A measure that can only be displayed by those with necessary privileges.
• C.A measure that cannot be referenced by a calculated column.
• D.A measure that can be consumed by a CUBE and not a DIMENSION.

Comment: *

Name: *

Email: *

Verification: *

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes. What is the correct approach?

• A.Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use the same star join node to connect the DIMENSIONS to the fact table.
• B.Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
• C.Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.
• D.Combine the transaction tables using a join node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.

Comment: *

Name: *

Email: *

Verification: *