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 DP-300 Exam - Topic 1 Question 119 Discussion

You have an Azure SQL database.You identify a long running query.You need to identify which operation in the query is causing the performance issue.What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
A) Live Query Statistics
B) an estimated execution plan
C) an actual execution plan
D) Client Statistics

Microsoft DP-300 Exam - Topic 1 Question 119 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 119
Topic #: 1
[All DP-300 Questions]

You have an Azure SQL database.

You identify a long running query.

You need to identify which operation in the query is causing the performance issue.

What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

Show Suggested Answer Hide Answer
Suggested Answer: A

https://www.mssqltips.com/sqlservertip/3685/live-query-statistics-in-sql-server-2016/


by Madonna at Aug 13, 2025, 11:58 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Brunilda
7 months ago
Wait, can you really see the actual execution plan in SSMS?
upvoted 0 times
...
Herminia
7 months ago
Estimated execution plan is just a guess, not reliable.
upvoted 0 times
...
Jutta
8 months ago
I thought Live Query Statistics was better for this?
upvoted 0 times
...
Reiko
8 months ago
Totally agree, C is the way to go!
upvoted 0 times
...
Janey
8 months ago
You should use an actual execution plan for this.
upvoted 0 times
...
Gaston
9 months ago
I practiced a similar question, and I think the actual execution plan is the best choice for identifying performance problems.
upvoted 0 times
...
Page
9 months ago
I feel like Live Query Statistics might help, but I’m not confident it shows the exact operations causing the issue.
upvoted 0 times
...
Devorah
9 months ago
I'm not entirely sure, but I remember something about estimated execution plans being useful for optimization before running the query.
upvoted 0 times
...
Gladys
9 months ago
I think we should use the actual execution plan to see what really happened during the query execution.
upvoted 0 times
...
Galen
9 months ago
I'm pretty confident that the actual execution plan is the way to go here. It should give me all the details I need to pinpoint the problematic operation and figure out how to optimize the query.
upvoted 0 times
...
Caren
10 months ago
Live Query Statistics sounds interesting, but I'm not sure if that's the best option for identifying the specific operation causing the performance issue. I think I'll stick with the actual execution plan to get a comprehensive view of the query.
upvoted 0 times
...
Stephanie
10 months ago
Hmm, I'm a bit unsure here. I know we can use the execution plan to identify performance issues, but I'm not sure if I should choose the actual or estimated plan. Maybe I'll review the differences between the two options before deciding.
upvoted 0 times
...
Kristofer
10 months ago
I think I'll go with option C - an actual execution plan. That should give me the most detailed information about the query's performance and where the bottleneck is.
upvoted 0 times
...
Johanna
11 months ago
C) an actual execution plan, no doubt. I'm not a fortune teller, I need the facts!
upvoted 0 times
...
Truman
11 months ago
B) an estimated execution plan? Nah, I want the real deal. I'm not playing guessing games with my database performance!
upvoted 0 times
Coletta
7 months ago
Same here! It’s all about getting the real data.
upvoted 0 times
...
Marta
7 months ago
I always go for the actual plan when troubleshooting.
upvoted 0 times
...
German
8 months ago
For sure! Estimations can be misleading.
upvoted 0 times
...
Titus
8 months ago
I totally agree! The actual execution plan gives the best insights.
upvoted 0 times
...
...
Gussie
12 months ago
C) an actual execution plan is the way to go. Gotta see what's really happening under the hood, you know?
upvoted 0 times
Alfreda
10 months ago
C) an actual execution plan
upvoted 0 times
...
Tijuana
10 months ago
B) an estimated execution plan
upvoted 0 times
...
Elliott
11 months ago
A) Live Query Statistics
upvoted 0 times
...
...
Casie
12 months ago
I think we should use C) an actual execution plan.
upvoted 0 times
...

Save Cancel