Exam MB-500 topic 7 question 21 discussion

Actual exam question from Microsoft's MB-500

Question #: 21
Topic #: 7

Users report that a company's Dynamics 365 Finance website is slow.

You suspect that a SQL query attached to the task GetFormInteractionTask is the cause.

You need to determine how long it takes for the query to run and return results.

What should you use?

A. Performance timer
B. Performance monitor
C. Microsoft Edge debugging tools
D. Fiddler

Show Suggested Answer

Suggested Answer: A 🗳️

by smithlaod at May 5, 2024, 4:54 a.m.

Comments

Submit Cancel

globeearth

1 month, 1 week ago

Selected Answer: A

why not B?. B. Performance monitor: This is more suited for system-wide performance metrics (e.g., CPU, memory usage) rather than specific query execution times.

upvoted 1 times

...

Justsumguybruh

7 months, 2 weeks ago

Answer is correct. Should be performance timer. To accurately measure the time taken for the SQL query to execute and return results, you should use a performance timer. This will allow you to precisely measure the duration of the query execution. Option A, "Performance timer," is the most appropriate choice for this task.

upvoted 2 times

...

smithlaod

7 months, 3 weeks ago

Wrong answer. Should be B. Use SQL Insight in Performance monitor to analyze sql perfomance issue.

upvoted 1 times

DANNYEXAMMB500

2 months, 2 weeks ago

A is correct, the specific task of determining how long a particular SQL query takes to run and return results, the Performance timer is more appropriate.

upvoted 1 times

...