Microsoft
70-458 · Question #110
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…
The correct answer is D. Drop the columnstore index. See the full explanation below for the reasoning.
Question
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?
Options
- AChange the recovery model of the database to Bulk-logged.
- BPause the columnstore index.
- CChange the non-clustered columnstore index to be a clustered columnstore index.
- DDrop the columnstore index.
How the community answered
(60 responses)- A2% (1)
- B13% (8)
- C7% (4)
- D78% (47)
Community Discussion
No community discussion yet for this question.