Microsoft
70-458 · Question #110
70-458 Question #110: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #110. The question stem and answer options stay visible for context.
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.
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.