DRAG DROP
A table named Table1 has a clustered columnstore index. The table contains over 10 billion records. This represents 12 years of sales data. The table is stored in a single filegroup.
You drop the existing columnstore index. You allocate 13 new filegroups with files large enough to store the entire table.
You need to implement a new columnstore index that supports maximum data compression for data older than 2 years.
Which four 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.
Select and Place:
