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 Exam DP-300 Topic 4 Question 96 Discussion

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

You have an Azure SQL database named DB1.

You need to display the estimated execution plan of a query by using the query editor in the Azure portal.

What should you do first?

Show Suggested Answer Hide Answer
Suggested Answer: D, E

by Delmy at Jul 16, 2024, 01:00 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Minna
2 months ago
D is the answer, no doubt. Trying to use Transact-SQL statements is like trying to open a jar with a sledgehammer. Just enable Query Store and let the Azure portal do the work!
upvoted 0 times
Gene
1 months ago
I agree, using Query Store simplifies the process. No need to complicate things with Transact-SQL statements.
upvoted 0 times
...
Aleisha
2 months ago
Exactly! Enabling Query Store for DB1 is the way to go. It makes it much easier to view the estimated execution plan.
upvoted 0 times
...
Rosendo
2 months ago
D is the answer, no doubt. Trying to use Transact-SQL statements is like trying to open a jar with a sledgehammer. Just enable Query Store and let the Azure portal do the work!
upvoted 0 times
...
...
Lavonda
2 months ago
I'm torn between B and D, but I think D is the way to go. Enabling Query Store is the most direct approach to get the estimated execution plan.
upvoted 0 times
Tijuana
1 months ago
Let's go with option D and enable Query Store for DB1.
upvoted 0 times
...
Viola
2 months ago
I agree, enabling Query Store for DB1 is the correct first step.
upvoted 0 times
...
Hillary
2 months ago
I think D is the way to go. Enabling Query Store is the most direct approach to get the estimated execution plan.
upvoted 0 times
...
...
Lashawn
3 months ago
I'm going with D. Enabling Query Store is the way to go here. Trying to use Transact-SQL statements seems a bit overkill for this task.
upvoted 0 times
Lindsay
1 months ago
User3: D) Enable Query Store for DB1.
upvoted 0 times
...
Dulce
2 months ago
User2: I agree, enabling Query Store for DB1 is the first step.
upvoted 0 times
...
Catalina
2 months ago
User1: I'm going with D. Enabling Query Store is the way to go here.
upvoted 0 times
...
...
Nichelle
3 months ago
B looks promising, but I'm not sure if setting the QUERY_CAPTURE_MODE is necessary to just view the execution plan. D seems like the more straightforward option.
upvoted 0 times
Ammie
1 months ago
Agreed, let's go with enabling Query Store for DB1.
upvoted 0 times
...
Annice
2 months ago
D) Enable Query Store for DB1.
upvoted 0 times
...
Lilli
2 months ago
I think D) Enable Query Store for DB1 is the better option.
upvoted 0 times
...
Alpha
3 months ago
B) For DB1, set QUERY_CAPTURE_MODE of Query Store to All.
upvoted 0 times
...
...
Freida
3 months ago
Hmm, I think the correct answer is D. Enabling Query Store for DB1 should allow me to view the estimated execution plan in the Azure portal. No need for any additional Transact-SQL statements.
upvoted 0 times
...
Yoko
3 months ago
I think running the set showplan_all Transact-SQL statement is the correct first step to display the estimated execution plan.
upvoted 0 times
...
Phung
3 months ago
I agree with An. Enabling Query Store will allow us to capture the execution plan.
upvoted 0 times
...
An
4 months ago
I think the first thing to do is to enable Query Store for DB1.
upvoted 0 times
...

Save Cancel