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.