Microsoft MB-700 Exam - 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%

Off

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

Contribute your Thoughts:

Submit Cancel

Bulah

4 months ago

Performance SDK could be a good option, but not for this specific issue.

upvoted 0 times

...

Bernardo

4 months ago

I disagree, Telemetry data monitoring is more useful for overall performance.

upvoted 0 times

...

Man

4 months ago

I’m surprised this is even a problem! Thought Dynamics was faster.

upvoted 0 times

...

Emerson

4 months ago

I think Index Analysis might help too, but not for blocking statements.

upvoted 0 times

...

Carry

5 months ago

Definitely go with SQL Insights - Live View for real-time issues.

upvoted 0 times

...

Jeanice

5 months ago

I definitely recall a question about SQL Insights, but I can't remember if Index Analysis was relevant for blocking statements.

upvoted 0 times

...

Edmond

5 months ago

I’m a bit confused; I thought Telemetry data monitoring could also help with performance issues.

upvoted 0 times

...

Soledad

5 months ago

I remember practicing with SQL Insights before, and I feel like Live View was specifically for real-time monitoring.

upvoted 0 times

...

Marguerita

5 months ago

I think we might need to use SQL Insights - Live View to check for blocking statements, but I'm not entirely sure.

upvoted 0 times

...

Sueann

5 months ago

Recorded videos could be really helpful for visually inspecting what happened during the failed test. I'll make sure to consider that option too.

upvoted 0 times

...

Casie

5 months ago

Okay, I've got this. Self-healing tools are designed to automatically detect and resolve issues, so the answer is likely related to automated recovery or escalation processes.

upvoted 0 times

...

Gussie

5 months ago

I feel like 10 could be the answer, but that seems high for most tasks. I'm leaning towards 0 or maybe even 3.

upvoted 0 times

...

Gianna

5 months ago

This is a tricky one. I'll need to think carefully about the different testing methodologies that are best suited for mobile apps.

upvoted 0 times

...

Viki

10 months ago

Ah, the age-old question of 'which tool should I use to fix my slow database?' I say we just throw the whole system out and start over. Problem solved!

upvoted 0 times

Gennie

8 months ago

D) Performance SDK

upvoted 0 times

...

Kizzy

8 months ago

C) Telemetry data monitoring

upvoted 0 times

...

Alyce

9 months ago

B) SQL Insights - Index Analysis

upvoted 0 times

...

Shaniqua

9 months ago

A) SQL Insights - Live View

upvoted 0 times

...

Reed

9 months ago

D: Performance SDK might be worth exploring to improve the response time of the system.

upvoted 0 times

...

Katy

9 months ago

C: Telemetry data monitoring could provide valuable insights into the system's performance.

upvoted 0 times

...

Erasmo

10 months ago

B: I think SQL Insights - Index Analysis might also help in this situation.

upvoted 0 times

...

Hailey

10 months ago

A: Let's try using SQL Insights - Live View to identify any blocking SQL statements.

upvoted 0 times

...

Fannie

11 months 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

Keith

9 months ago

Yeah, the Performance SDK might be too heavy-handed for just identifying blocking SQL statements.

upvoted 0 times

...

Isreal

10 months ago

I agree, the SQL Insights tools would be more targeted and efficient in this situation.

upvoted 0 times

...

Lucina

11 months ago

I'm not sure, maybe Telemetry data monitoring could also be useful in this situation.

upvoted 0 times

...

Viva

11 months ago

I agree with Nickolas, SQL Insights - Live View can help us pinpoint the issue with slow response time.

upvoted 0 times

...

Lai

11 months 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

Glennis

9 months ago

D: Let's try using SQL Insights - Live View first and see if we can identify any blocking SQL statements.

upvoted 0 times

...

Mollie

9 months ago

C: Yeah, those options would give us more specific information about the performance issues we're facing.

upvoted 0 times

...

Elouise

10 months ago

B: I agree. We should probably use SQL Insights - Live View or SQL Insights - Index Analysis for that.

upvoted 0 times

...

Jutta

10 months 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

11 months 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

11 months 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

11 months ago

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

upvoted 0 times

...