70-450 · Question #70
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…
The correct answer is C. The clustered index of the Orders table should be excluded from scheduled reorganizing or. As the users will continuously access the database and there is one cluster index, the cluster index could not be unavailable because the leaf pages of the clustered index contains the table Furthermore, the cluster index has never one fragmentation of more than 2%, this means…
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.
How the community answered
(42 responses)- A5% (2)
- B7% (3)
- C71% (30)
- D17% (7)
Explanation
As the users will continuously access the database and there is one cluster index, the cluster index could not be unavailable because the leaf pages of the clustered index contains the table Furthermore, the cluster index has never one fragmentation of more than 2%, this means it doesn't need to be reordered. With this, you can be sure that answer A,B and D are wrong.
Topics
Community Discussion
No community discussion yet for this question.