Microsoft
70-450 · Question #70
70-450 Question #70: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
Question
You are a professional level SQL Sever 2008 Database Administrator. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. - First, the users continuously access to the Orders table in the database. - Secondly, a column of the xml data type is contained by Orders table. - Thirdly, the new rows are regularly added to the Orders table. - Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent. A strategy should be designed to have the performance of the queries on the table optimized. Which action will you perform?
Options
- AThe clustered index of the Orders table should be dropped.
- BThe clustered index of the Orders table offline should be rebuilt once a month.
- CThe clustered index of the Orders table should be excluded from scheduled reorganizing or
- DThe clustered index of the Orders table should be reorganized by reducing the fill factor.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.