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.)
Which three actions should you perform in sequence?
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.)
THe next article about xvelocity says:
To enable this, your IT staff can simply use SQL Server Management Studio to create the column store.
https://blogs.technet.microsoft.com/dataplatforminsider/2012/03/08/introducing-xvelocity-in-memory-technologies-in-sql-server-2012-for-10-100x-performance/
So THE Correct Way seems: table+load+column store
Agreed
Create the table.
Load the data.
Create the columnstore index.
again, dbo hit the nail