DRAG DROP
You need to design a data load strategy for a data warehouse fact table. The solution must use an
ordered data load.
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.
Leave a Reply
https://blogs.msdn.microsoft.com/sqlcat/2015/03/11/data-loading-performance-considerations-with-clustered-columnstore-indexes/
In case of initial load:
Load Data into a Heap
Create a Clustered index for key column
Create a Clustered Columnstore index with DROP_EXISTING
In case of incremental:
Load Data into a Heap
Create a Clustered index for key column
Partition table by using
the answer is
load data into heap
create a clustered index
Create a Clustered Columnstore index with DROP_EXISTING