DP-300 Practice Question: Monitor, configure, and optimize database resources
You are managing an Azure SQL Database that has automatic tuning enabled. You notice that a recent index creation recommended by automatic tuning has caused a performance regression for some queries. You need to revert the change and prevent automatic tuning from applying similar recommendations in the future. What should you do?
⚠ Common exam trap
The trap here is thinking that disabling automatic tuning entirely is necessary, when you can revert the specific change and disable only the index creation option.
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
✓
Use the automatic tuning option to revert the last change and then disable the CREATE INDEX tuning option.
Automatic tuning in Azure SQL Database allows you to revert individual tuning actions. To address the regression, you should revert the index creation and then disable the CREATE INDEX tuning option to prevent future automatic index creation. Disabling all automatic tuning or using manual workarounds like DDL triggers are less precise and can have unintended side effects.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Disable automatic tuning on the database.
Why it's wrong here
Disabling automatic tuning entirely would stop all automatic tuning actions, including index creation and plan correction. While it would prevent future similar recommendations, it is a broad action that also disables beneficial features. The requirement is to revert the change and prevent similar recommendations, not to disable all automatic tuning. Therefore, this is not the most appropriate action.
- ✓
Use the automatic tuning option to revert the last change and then disable the CREATE INDEX tuning option.
Why this is correct
Automatic tuning provides a history of applied recommendations and allows you to revert a specific change. After reverting the index creation, you can disable the CREATE INDEX tuning option to prevent automatic tuning from creating indexes in the future. This targeted approach addresses both the immediate issue and the future prevention without disabling other tuning features.
- ✗
Manually drop the index and create a database-level DDL trigger to block index creation.
Why it's wrong here
Dropping the index manually would revert the change, but creating a DDL trigger to block all index creation is an overreach and could interfere with legitimate index maintenance. It does not leverage the built-in automatic tuning controls. This approach is more complex and may have unintended consequences, such as blocking necessary index creations by administrators.
- ✗
Set the automatic tuning option to inherit from the server and disable it at the server level.
Why it's wrong here
Disabling automatic tuning at the server level would affect all databases on the server, which is broader than necessary. It would also not specifically revert the change; you would still need to manually drop the index. This approach is not targeted and could disrupt tuning for other databases that benefit from it.
Go deeper
Related to this question
Learn chapter
Optimizing Database Query and Index Performance
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
One of 574 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.