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
agree
agreed D)
D
maybe pause = disable?
Its Drop. Question says ‘Pause’. We just cannot assume anything for our sake.
D
D. Drop the co…
D
http://www.codeproject.com/Questions/748395/answer.aspx — 1st question
D