Answers to Review Questions

  1. D. Microsoft recommends that you rebuild the index when avg_fragmentation_in_percent is greater than 30. Rebuilding the index will also update the statistics. Rebuilding the statistics by itself will not solve the problem because the table is heavily fragmented.
  2. A. The script host utility (rs.exe) runs custom Visual Basic scripts against multiple report server instances.
  3. C. The Database Maintenance Plan Wizard is designed to create simple database maintenance plans quickly and easily. They can then be customized further through the Database Maintenance design surface if required.
  4. B. MOM allows you to implement a proactive monitoring and alerting solution against your SQL Server instances.
  5. B. The reportserver system ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial