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…
Question
Options
- AYes
- BNo
How the community answered
(26 responses)- A27% (7)
- B73% (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
Community Discussion
No community discussion yet for this question.