nerdexam
Microsoft

MB-700 · Question #199

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. The solution does NOT meet the goal. While SQL Insights in LCS does include database health features such as table fragmentation analysis and index rebuild recommendations, these address database maintenance concerns rather than diagnosing why specific forms and reports are…

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: Get table fragmentation details and index rebuild suggestions. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(30 responses)
  • A
    20% (6)
  • B
    80% (24)

Explanation

The solution does NOT meet the goal. While SQL Insights in LCS does include database health features such as table fragmentation analysis and index rebuild recommendations, these address database maintenance concerns rather than diagnosing why specific forms and reports are slow. To investigate form and report performance issues, the appropriate SQL Insights feature is 'Expensive Queries,' which identifies long-running queries, execution plans, and resource consumption tied directly to the slow UI operations. Table fragmentation analysis is a valid LCS tool but answers a different question (overall database health), making it the wrong solution for this specific performance investigation scenario.

Topics

#Performance troubleshooting#Dynamics 365 Finance#Lifecycle Services (LCS)#SQL Insights

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full MB-700 Practice