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.