Microsoft
70-450 · Question #11
70-450 Question #11: Real Exam Question with Answer & Explanation
The correct answer is D. Exclude the clustered index of the Orders table from scheduled reorganizing or rebuilding. Since the clustered index never has any significant fragmentation, there's no reason to rebuild or
Question
You administer a SQL Server 2008 infrastructure. You plan to design a maintenance strategy for a mission-critical database that includes a large table named Orders. The design plan includes index maintenance operations. You must design the strategy after considering the following facts: - The Orders table in the database is constantly accessed. - New rows are frequently added to the Orders table. - The average fragmentation for the clustered index of the Orders table is less than 2 percent. - The Orders table includes a column of the xml data type. You need to implement the strategy so that the performance of the queries on the table is optimized. What should you do?
Options
- ADrop the clustered index of the Orders table.
- BRebuild the clustered index of the Orders table offline once a month.
- CReorganize the clustered index of the Orders table by decreasing the fill factor.
- DExclude the clustered index of the Orders table from scheduled reorganizing or rebuilding
Explanation
Since the clustered index never has any significant fragmentation, there's no reason to rebuild or
Community Discussion
No community discussion yet for this question.