nerdexam
Microsoft

MB-700 · Question #114

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…

The correct answer is B. No. No, this solution does not meet the goal. Disabling and enabling page locks and lock escalation is a database-level configuration change - a remediation action - not an investigation. SQL Insights in LCS provides read-only diagnostic visibility into the Azure SQL database…

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: Disable and enable page locks and lock escalation. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(26 responses)
  • A
    27% (7)
  • B
    73% (19)

Explanation

No, this solution does not meet the goal. Disabling and enabling page locks and lock escalation is a database-level configuration change - a remediation action - not an investigation. SQL Insights in LCS provides read-only diagnostic visibility into the Azure SQL database underlying Dynamics 365, including blocked queries, expensive queries, and resource usage metrics. It does not give users direct DDL or database configuration access. The task is to investigate the performance issue, not to modify database locking behavior. This solution attempts to fix a symptom without first using SQL Insights to diagnose what is actually causing the slowness.

Topics

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

Community Discussion

No community discussion yet for this question.

Full MB-700 Practice