You are designing a data warehouse that uses SQL Server 2012. You are preparing to
update the contents of a fact table that contains a non-clustered columnstore index.
You need to run an update statement against the table.
What should you do first?
A.
Pause the columnstore index.
B.
Change the recovery model of the database to Bulk-logged.
C.
Change the non-clustered columnstore index to be a clustered columnstore index.
D.
Drop the columnstore index.
D definitely, there is no option of “pausing” an index.
Option D:
**Drop columnstore index
**Load data/update fact table
**Re-create columnstore index
Optin D is correct as Faisal right no pausing index option available in SQL