DP-300 Configure and manage automation of tasks Practice Question
You have an Azure SQL Database that uses automatic tuning. You notice that a forced plan regression is causing performance degradation. You need to revert to the previous plan and prevent the automatic tuning from forcing the same plan again. What should you do?
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
✓
Create a plan guide for the previous plan and then disable the automatic tuning recommendation for that query.
Creating a plan guide for the previous plan manually enforces that plan for the query, and disabling the automatic tuning recommendation for that specific query prevents the automatic tuning engine from forcing the same plan again. Option A is incorrect because reindexing may not resolve the regression and does not stop automatic tuning from forcing the bad plan. Option C is incorrect because disabling automatic tuning globally affects all queries unnecessarily. Option D is incorrect because clearing the plan cache is only temporary and automatic tuning would likely force the same plan again.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Reindex the tables involved in the query.
Why it's wrong here
Reindexing may change statistics but does not directly address plan regression or automatic tuning.
- ✓
Create a plan guide for the previous plan and then disable the automatic tuning recommendation for that query.
Why this is correct
A plan guide forces the previous plan, and disabling the recommendation prevents automatic tuning from reverting it.
- ✗
Disable automatic tuning for the database.
Why it's wrong here
This disables all automatic tuning, which is too broad.
- ✗
Run DBCC FREEPROCCACHE to clear the plan cache.
Why it's wrong here
Clearing the plan cache is temporary and does not prevent automatic tuning from forcing the bad plan again.
Visual reference
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
Courseiva writes every DP-300 question from scratch — 906 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.