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?
A.
The clustered index of the Orders table should be dropped.
B.
The clustered index of the Orders table should be reorganized by reducing the fill factor.
C.
The clustered index of the Orders table should be excluded from scheduled reorganizing
or rebuilding operations.
D.
The clustered index of the Orders table offline should be rebuilt once a month.