PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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