Question 900
An Azure SQL database experiences intermittent latency and operations wants top resource-consuming queries over time. Initial testing shows: Optimized statements reduce resource peaks under repeated workload. Which limitation should the team still consider?
Explanation
Correct Answer
Monitoring metrics do not by themselves identify causal application behavior. Azure SQL query insights and Query Store can reveal resource-heavy query trends. Analyze top statements and correlate plan/runtime changes with traffic.
Incorrect Answers
Use supported Query Store/performance insights with time windows and statement/runtime evidence.
Align telemetry windows to the incidents and inspect distribution, frequency and plan variance.
Correlate plan/run-time trends with parameter mix, application traffic and deployment events. The genuine residual limitation is: Monitoring metrics do not by themselves identify causal application behavior.