DP-300 Query Store Practice Question
You need to recommend a performance monitoring solution for a new Azure SQL Managed Instance deployment. The solution must provide historical query performance data and the ability to compare performance before and after index changes. What should you include in the recommendation?
⚠ Common exam trap
Many candidates confuse Query Store with DMVs or Azure SQL Analytics. Remember that Query Store is specifically designed for historical query performance tracking and plan regression analysis.
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
✓
Query Store with custom retention settings
Query Store captures historical query performance data and allows comparing performance before and after index changes, making it the correct choice for this requirement. SQL Server DMVs (Option B) only provide current state, not historical trends. Azure SQL Analytics solution (Option C) provides aggregated metrics but lacks per-query historical comparison. Intelligent Insights (Option D) offers diagnostic analysis but not detailed historical query data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Query Store with custom retention settings
Why this is correct
Correct. Query Store with custom retention settings provides historical query performance data and enables performance comparison before and after index changes.
- ✗
SQL Server DMVs
Why it's wrong here
Incorrect. SQL Server DMVs offer real-time performance data but do not store historical query performance for comparison.
- ✗
Azure SQL Analytics solution in Log Analytics
Why it's wrong here
Incorrect. Azure SQL Analytics in Log Analytics provides aggregated metrics and alerts, but not per-query historical comparison.
- ✗
Azure SQL Database Intelligent Insights
Why it's wrong here
Incorrect. Intelligent Insights provides automated diagnostics and recommendations, but not detailed historical query data.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed cloud database service that gives you nearly all the features of Microsoft SQL Server on your own server, without you having to manage the hardware or operating system.
Key term
Query Store
Query Store is a built-in SQL Server feature that captures and stores a history of query execution plans and performance data for easy monitoring and troubleshooting.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.