Index Maintenance Strategies 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 reason to perform index maintenance on a database table?
  2. When deciding between an 'Index Reorganize' and an 'Index Rebuild' operation, which statement is true?
  3. You notice that your database indices have a fragmentation level of 8%. Based on standard maintenance best practices, what is the recommended action?
  4. What is the primary risk of performing an 'Index Rebuild' operation on a large table in a high-concurrency production environment?
  5. In a scenario where a table experiences a high volume of random inserts, which index property should be adjusted to minimize page splits and subsequent fragmentation?

Answers and explanations come after you submit.