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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft MB-700 Exam - Topic 3 Question 61 Discussion

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?
A) SQL Insights - Live View and D) Performance SDK
B) SQL Insights - Index Analysis
C) Telemetry data monitoring

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?

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.


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:

0/2000 characters
Submit Cancel
Bulah
7 months ago
Performance SDK could be a good option, but not for this specific issue.
upvoted 0 times
...
Bernardo
7 months ago
I disagree, Telemetry data monitoring is more useful for overall performance.
upvoted 0 times
...
Man
7 months ago
I’m surprised this is even a problem! Thought Dynamics was faster.
upvoted 0 times
...
Emerson
8 months ago
I think Index Analysis might help too, but not for blocking statements.
upvoted 0 times
...
Carry
8 months ago
Definitely go with SQL Insights - Live View for real-time issues.
upvoted 0 times
...
Jeanice
8 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
8 months ago
I’m a bit confused; I thought Telemetry data monitoring could also help with performance issues.
upvoted 0 times
...
Soledad
8 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
8 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
8 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
8 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
8 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
8 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
1 year 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
12 months ago
D) Performance SDK
upvoted 0 times
...
Kizzy
12 months ago
C) Telemetry data monitoring
upvoted 0 times
...
Alyce
12 months ago
B) SQL Insights - Index Analysis
upvoted 0 times
...
Shaniqua
12 months ago
A) SQL Insights - Live View
upvoted 0 times
...
Reed
1 year ago
D: Performance SDK might be worth exploring to improve the response time of the system.
upvoted 0 times
...
Katy
1 year ago
C: Telemetry data monitoring could provide valuable insights into the system's performance.
upvoted 0 times
...
Erasmo
1 year ago
B: I think SQL Insights - Index Analysis might also help in this situation.
upvoted 0 times
...
Hailey
1 year ago
A: Let's try using SQL Insights - Live View to identify any blocking SQL statements.
upvoted 0 times
...
...
Fannie
1 year 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
1 year ago
Yeah, the Performance SDK might be too heavy-handed for just identifying blocking SQL statements.
upvoted 0 times
...
Isreal
1 year ago
I agree, the SQL Insights tools would be more targeted and efficient in this situation.
upvoted 0 times
...
...
Lucina
1 year ago
I'm not sure, maybe Telemetry data monitoring could also be useful in this situation.
upvoted 0 times
...
Viva
1 year ago
I agree with Nickolas, SQL Insights - Live View can help us pinpoint the issue with slow response time.
upvoted 0 times
...
Lai
1 year 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
1 year 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
1 year ago
C: Yeah, those options would give us more specific information about the performance issues we're facing.
upvoted 0 times
...
Elouise
1 year ago
B: I agree. We should probably use SQL Insights - Live View or SQL Insights - Index Analysis for that.
upvoted 0 times
...
Jutta
1 year 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
1 year 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
1 year 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
1 year ago
I think we should use SQL Insights - Live View to identify blocking SQL statements.
upvoted 0 times
...

Save Cancel