Performance Recommendations Quiz

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

Quiz covering Automatic Tuning

What you'll be asked

  1. What is the primary purpose of an Automatic Tuning feature in a database management system?
  2. When reviewing performance recommendations, why is it recommended to test them in a staging environment before applying them to production?
  3. If an Automatic Tuning system suggests creating a new index, what is the most important factor to consider before approving it?
  4. What does it mean when an Automatic Tuning recommendation is marked as 'Force Last Good Plan'?
  5. In a high-concurrency environment, why might an Automatic Tuning recommendation to 'Drop Unused Index' be risky if the index is only used by a monthly reporting job?

Answers and explanations come after you submit.