Microsoft Exam MB-700 Topic 3 Question 61 Discussion

Actual exam question for Microsoft's MB-700 exam

Question #: 61
Topic #: 3

[All MB-700 Questions]

A company uses Dynamics 365 Supply Chain Management.

The system has a slow response time when sales orders are entered.

You need to identify any blocking SQL statements.

Which Lifecycle Services (LCS) tool should you use?

ASQL Insights - Live View

BSQL Insights - Index Analysis

CTelemetry data monitoring

DPerformance SDK

Show Suggested Answer

Suggested Answer: A, D

AD: Live View -- Shows executing statements and blocking statements.

A: Sample flow

Scenario: Users report slow performance when using the system. One issue could be a blocking statement. Blocking by itself is typical in a healthy system and is only a problem when it becomes excessive or starts degrading business activities.

Go to the Live View tab and check if there are any blocking statements. If there is a blocking statement, copy the blocking query ID.

Open the Queries tab and select the Current Blocking Tree query. This will return the root blocker that is blocking the SQL operation.

Etc.

by My at Feb 24, 2023, 10:08 AM

Limited Time Offer

25%

23 days ago

I'm not sure about the Telemetry data monitoring option. Isn't that more for general system health monitoring rather than specific performance issues?

upvoted 0 times

Jutta

10 days ago

A: I think you're right. Telemetry data monitoring might not be the best option for identifying blocking SQL statements.

upvoted 0 times

...

Josephine

24 days ago

The SQL Insights - Index Analysis tool could also be useful here. It can help you identify any index-related performance issues that might be causing the slow response time.

upvoted 0 times

...

Isidra

25 days ago

Hmm, this is a tricky one. I think the SQL Insights - Live View tool would be the best option to identify any blocking SQL statements. It gives you a real-time view of the database activity, right?

upvoted 0 times

...

Nickolas

25 days ago

I think we should use SQL Insights - Live View to identify blocking SQL statements.

upvoted 0 times

...