DP-300 Practice Question: Monitor, configure, and optimize database resources
Exhibit
Azure SQL Database automatic tuning recommendations: Recommendation ID: 1 Type: CREATE_INDEX Reason: Improve query performance Score: 80 State: Active Impacted queries: 3 Recommendation ID: 2 Type: DROP_INDEX Reason: Index not used Score: 90 State: Pending verification Impacted queries: 0 Recommendation ID: 3 Type: FORCE_LAST_GOOD_PLAN Reason: Regression detected Score: 100 State: Active Impacted queries: 1 Current query performance metrics for impacted query of recommendation 3: Before plan change: avg CPU 500 ms, avg duration 1000 ms After plan change: avg CPU 1000 ms, avg duration 2000 ms
Refer to the exhibit. An automatic tuning recommendation to force the last good plan is active. What should the database administrator do next?
⚠ Common exam trap
Azure often tests the misconception that an automatic tuning recommendation should be immediately implemented or reverted without first monitoring its impact, leading candidates to choose premature actions like dropping indexes or reverting plans.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Monitor the query performance to confirm the forced plan resolves the regression
When an automatic tuning recommendation to force the last good plan is active, the correct next step is to monitor the query performance to confirm that the forced plan resolves the regression. This is because plan forcing is a corrective action that may or may not improve performance; validation through monitoring ensures the change is beneficial before taking further steps like creating or dropping indexes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Immediately implement the DROP_INDEX recommendation to reduce overhead
Why it's wrong here
The DROP_INDEX is pending verification and not directly related.
- ✗
Create the recommended index to improve performance
Why it's wrong here
The CREATE_INDEX recommendation targets different queries.
- ✗
Revert the plan force because it is causing regression
Why it's wrong here
The regression was after the plan change; forcing last good plan should help.
- ✓
Monitor the query performance to confirm the forced plan resolves the regression
Why this is correct
The active recommendation should be monitored for effectiveness.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 906 original DP-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.