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 3

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


Faisal

Faisal

D definitely, there is no option of “pausing” an index.

Slazenjer_m

Slazenjer_m

Option D:

**Drop columnstore index
**Load data/update fact table
**Re-create columnstore index

Jass

Jass

Optin D is correct as Faisal right no pausing index option available in SQL