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: Load the data.
Box 3: Create the columnstore index with the MAXDOP keyword.Only nonclustered columnstore indexes are available in SQL Server 2012 so when the index is created,
you cannot update the table (without using partition switching). Therefore you have to load the data
BEFORE creating the index.
In SQL Server 2014, you could create a clustered columnstore index which would allow updates to the
table after the index is created.