MB-700 · Question #115
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might h
The correct answer is A. Yes. Yes, this solution meets the goal. Checking for blocked queries and high DTU (Database Throughput Units) usage is precisely what SQL Insights in LCS is designed for. SQL Insights provides dashboards showing query blocking chains, long-running queries, DTU utilization over time, i
Question
Options
- AYes
- BNo
How the community answered
(47 responses)- A79% (37)
- B21% (10)
Explanation
Yes, this solution meets the goal. Checking for blocked queries and high DTU (Database Throughput Units) usage is precisely what SQL Insights in LCS is designed for. SQL Insights provides dashboards showing query blocking chains, long-running queries, DTU utilization over time, index usage, and wait statistics. High DTU indicates resource saturation, and blocked queries indicate lock contention - both are common root causes of forms and reports taking longer to open and run. This is an investigation activity that directly uses the SQL Insights toolset to diagnose the performance problem, satisfying the stated requirement.
Topics
Community Discussion
No community discussion yet for this question.