Free Preparation Discussions
MENU
Microsoft Exam MB-700 Topic 2 Question 63 Discussion
Topic #: 2
A company implements Dynamics 365 Supply Chain Management.
The company uses a third-party analytics software solution for reporting. The solution requires permissions to ensure T-SQL code can access data.
The company must include Dynamics 365 Supply Chain Management data in the analytics software solution to display data in a single view with other data.
You need to identify the correct data analytics approach.
Which solution should you use?
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.
Bettina
2 months agoFreida
1 days agoCordell
3 days agoGabriele
6 days agoDwight
11 days agoFranklyn
25 days agoAretha
26 days agoLudivina
2 months agoRosita
2 months agoCathrine
1 months agoLizbeth
2 months agoJoye
2 months agoSang
2 months agoMinna
2 months agoViola
21 days agoIvan
26 days agoLelia
1 months agoLasandra
2 months agoGlory
2 months agoSang
3 months ago