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.

Show Hint

Leave a Reply 3

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

jack johnson

jack johnson

“Tables that have a columnstore index cannot be updated. There are three ways to work around this problem.
To update a table with a columnstore index, drop the columnstore index, perform any required INSERT, DELETE, UPDATE, or MERGE operations, and then rebuild the columnstore index.”
Books Online ColumnStore Index Best Practices
D. Is the correct answer.

Reply