MicrosoftMicrosoft
DP-300 · Question #165
DP-300 Question #165: Real Exam Question with Answer & Explanation
The correct answer is C: Run sys.dm_exec_query_plan_stats.. https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-exec-query-plan-stats-transact-sql?view=sql-server-ver15
Submitted by neha2k· Mar 6, 2026Optimize query performance
Question
You have an Azure SQL managed instance. You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries. What should you do?
Options
- AGenerate an estimated execution plan.
- BGenerate an actual execution plan.
- CRun sys.dm_exec_query_plan_stats.
- DGenerate Live Query Statistics.
Explanation
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-exec-query-plan-stats-transact-sql?view=sql-server-ver15
Community Discussion
No community discussion yet for this question.