DRAG DROP
You are building a fact table in a data warehouse.
The table must have a columnstore index. The table cannot be partitioned.
You need to design the fact table and load it with data.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Explanation:
Box 1: Create the fact table.
Box 2: Create the columnstore index with the MAXDOP keyword.
Box 3: Load the data.
In my opinion it should be:
Box 1: Create the fact table.
Box 2: Load the data.
Box 3: Create the columnstore index with the MAXDOP keyword.
This question is meant to trick you. Maxdop is useless here, but include (for include columns) and asc (for order rows ascending) are impossible. You have to know that and set the maximum degree of parallelism. The best is to use no key word.
Box 1: Create the fact table.
Box 2: Load the data.
Box 3: Create the columnstore index with the MAXDOP keyword.
Using INCLUDE and ASC is not possible with columnstore index.
“Cannot be created by using the INCLUDE keyword.”
“Cannot include the ASC or DESC keywords for sorting the index.”
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql