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.The block must start with a node that defines a table as a data source.
• B.Only one block can be defined across a stack of calculation views.
• C.The block must only have one start node.
• D.Multiple blocks can only be defined within a single calculation view.

Comment: *

Name: *

Email: *

Verification: *

What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question. Improved write performance on frequent updates.

• A.Additional indexes are used
• B.Parallel access is improved
• C.Higher data compression rates
• D.Higher performance for query operations

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

You have generated a calculation view properties file. What does it contain?

• A.Descriptions of all objects defined in a calculation view
• B.All settings defined in a calculation view
• C.Documentation to support the calculation view
• D.Dependencies between calculation views

Comment: *

Name: *

Email: *

Verification: *

What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.

• A.It CANNOT be mixed in the same star join node with other join types.
• B.It must appear in the last DIMENSION in the star join node.
• C.It is restricted to one DIMENSION in a star join node.
• D.Only one column can be included in the join condition.

Comment: *

Name: *

Email: *

Verification: *