Microsoft MB-700 Exam - Topic 1 Question 59 Discussion

Actual exam question for Microsoft's MB-700 exam

Question #: 59
Topic #: 1

[All MB-700 Questions]

A company uses Dynamics 365 Finance. The company experiences performance issues with several forms in production.

You need to use Live View SQL performance metrics to identity potential issues that occur in real time.

You need to recommend a solution to troubleshoot performance issues.

Which two performance metrics should the company use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

ABlocking statements

BBatch requests

CDatabase File 10

DExecuting statements

EExecuting indexes

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 Jennifer at Jan 04, 2023, 06:34 AM

Limited Time Offer

25%

Off

Get Premium MB-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Timothy

4 months ago

Totally agree, those metrics are key for troubleshooting!

upvoted 0 times

...

Dominque

4 months ago

Wait, what's Database File 10? Sounds kinda random.

upvoted 0 times

...

Muriel

5 months ago

Blocking statements are a must! Can't believe some might overlook that.

upvoted 0 times

...

Garry

5 months ago

I think Batch requests could be useful too, but not sure about the others.

upvoted 0 times

...

Sue

5 months ago

Definitely go with Blocking statements and Executing statements.

upvoted 0 times

...

Eladia

5 months ago

I vaguely recall something about executing indexes, but I'm not confident if that's directly related to real-time performance issues.

upvoted 0 times

...

Dolores

5 months ago

I feel like batch requests might be relevant too, especially since they can indicate how many queries are being processed at once.

upvoted 0 times

...

Moira

5 months ago

I'm not entirely sure, but I think executing statements could help us see which queries are taking the longest.

upvoted 0 times

...

Maryann

5 months ago

I remember we discussed blocking statements in class; they seem crucial for identifying performance bottlenecks.

upvoted 0 times

...

Yesenia

5 months ago

The MIB, or Management Information Base, is the key element that defines the attributes of the managed device. I'm confident that's the right answer.

upvoted 0 times

...

Tori

6 months ago

Ah, I remember learning about this in class. The Collect Requirements process is part of the Scope Management knowledge area. Glad I brushed up on my PMBOK knowledge before the exam!

upvoted 0 times

...