Microsoft
70-463 · Question #226
70-463 Question #226: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #226. 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
- APause the columnstore index.
- BChange the recovery model of the database to Bulk-logged.
- CChange the non-clustered columnstore index to be a clustered columnstore index.
- DDrop the columnstore index.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 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.