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.
I think that Columnstore Index should be created last – as it makes the table read only. The solution is to either disable it or partition the table – which the question doesn’t allow.
Plus I’m not sure that MaxDOP is a correct hint…
Therefore:
1.Create the Fact Table
2.Load The Data
3.Create Columnstore with INCLUDE keyword
MAXDOP is only hint possible for columnstore index.
https://technet.microsoft.com/en-us/library/gg492153(v=sql.110).aspx
1.Create the Fact Table
2.Load The Data
3.Create Columnstore with the MAXDOP keyword
You do not need MAXDOP but it is the only valid one