nerdexam
Microsoft

MB-700 · Question #113

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 B. No. No, this solution does not meet the goal. The question asks to investigate a performance issue using SQL Insights in LCS - a diagnostic and monitoring activity. Creating a non-unique index on a table is a remediation action, not an investigation action. SQL Insights is used to an

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: Create a non-unique index on a table. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(53 responses)
  • A
    17% (9)
  • B
    83% (44)

Explanation

No, this solution does not meet the goal. The question asks to investigate a performance issue using SQL Insights in LCS - a diagnostic and monitoring activity. Creating a non-unique index on a table is a remediation action, not an investigation action. SQL Insights is used to analyze query performance, identify slow queries, view DTU consumption, and detect blocking - all diagnostic activities. While adding an index might eventually help performance after the root cause is identified, it does not constitute using SQL Insights to investigate the problem. The solution conflates diagnosis with remediation and therefore does not satisfy the stated requirement.

Topics

#Performance troubleshooting#Lifecycle Services (LCS)#SQL Insights#Database optimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full MB-700 Practice