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…

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.

How the community answered

(50 responses)

A
8% (4)
B
4% (2)
C
74% (37)
D
14% (7)

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.

Full DP-300 Practice