Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide 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.


Contribute your Thoughts:

Fannie
3 days ago
The Performance SDK? That's like using a sledgehammer to crack a nut. I'd go with the SQL Insights tools instead. They're designed specifically for this kind of problem.
upvoted 0 times
...
Lucina
5 days ago
I'm not sure, maybe Telemetry data monitoring could also be useful in this situation.
upvoted 0 times
...
Viva
6 days ago
I agree with Nickolas, SQL Insights - Live View can help us pinpoint the issue with slow response time.
upvoted 0 times
...
Lai
8 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
...
Josephine
9 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
10 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
10 days ago
I think we should use SQL Insights - Live View to identify blocking SQL statements.
upvoted 0 times
...

Save Cancel