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.)
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
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
0
0
Agreed
0
0
Create the table.
Load the data.
Create the columnstore index.
0
0
again, dbo hit the nail
0
0