Question 1
When is the first column store compression executed?
Question 2
Using the table in the diagram, you need to create a CUBE calculation view. What is the simplest approach to create the output shown in the screenshot?
Question 3
Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.
Question 4
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.
Question 5
Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.