Maintenance Plan Creation Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Database Maintenance

What you'll be asked

  1. Which of the following is the primary purpose of running a database maintenance plan?
  2. When configuring an index maintenance task, why is it recommended to choose 'Reorganize' over 'Rebuild' for moderately fragmented indexes?
  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. What is the primary risk associated with frequently running the 'Shrink Database' task in a production environment?
  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?

Answers and explanations come after you submit.