nerdexam
Microsoft

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

Manage implementations

Question

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 have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company implements Dynamics 365 Finance. Forms and reports take longer than usual to open and run in the production environment. You need to investigate the performance issue by using SQL Insights in Lifecycle Services (LCS). Solution: Check for blocked queries and high DTU. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(47 responses)
  • A
    79% (37)
  • B
    21% (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

#LCS SQL Insights#Performance troubleshooting#Dynamics 365 Finance#Database performance

Community Discussion

No community discussion yet for this question.

Full MB-700 Practice