You need to run an update statement against the table

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?

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.



Leave a Reply 10

Your email address will not be published. Required fields are marked *


Lumi

Lumi

maybe pause = disable?

Jai

Jai

Its Drop. Question says ‘Pause’. We just cannot assume anything for our sake.

MKL

MKL

D. Drop the co…