Maintenance Plan Creation Quiz

Quiz covering Database Maintenance

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   Which of the following is the primary purpose of running a database maintenance plan?

2. 2

   When configuring an index maintenance task, why is it recommended to choose 'Reorganize' over 'Rebuild' for moderately fragmented indexes?

3. 3

   Which task is essential to perform after a large volume of data has been modified to ensure the Query Optimizer makes efficient execution plans?

4. 4

   What is the primary risk associated with frequently running the 'Shrink Database' task in a production environment?

5. 5

   You are designing a maintenance plan for a high-transaction database. You need to ensure that index maintenance does not block user access to tables during business hours. Which configuration strategy should you implement?