Question 1
A team needs live evidence of currently waiting SQL sessions and blocking relationships, not a historical average chart. Which recommendation best resolves this issue?
Explanation
Correct Answer
DMVs surface near-real-time engine state that historical aggregates alone cannot show.
Incorrect Answers
Parameterize stable query shapes so telemetry and plan analysis can group comparable executions; consistent query text improves observability and plan reuse compared with literal-heavy variants.
Review Query Store's plan and runtime history to identify an eligible regression and validate a remedial plan; query Store helps correlate query performance changes with execution plan versions over time.
Review available Query Performance Insight metrics and crosscheck them with Query Store and application timings; portal query analytics can highlight high-cost workloads but should be interpreted with measured context.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests