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?

ARun the set showplan_all Transact-SQL statement.

BFor DB1, set QUERY_CAPTURE_MODE of Query Store to All.

CRun the set forceplan Transact-SQL statement.

DEnable Query Store for DB1.

Show Suggested 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

19 days 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

Aleisha

1 days 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

3 days 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

25 days 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

Viola

2 days ago

I agree, enabling Query Store for DB1 is the correct first step.

upvoted 0 times

...

Hillary

18 days 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

1 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

Catalina

13 days ago

User1: I'm going with D. Enabling Query Store is the way to go here.

upvoted 0 times

...

Nichelle

1 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

Annice

1 days ago

D) Enable Query Store for DB1.

upvoted 0 times

...

Lilli

3 days ago

I think D) Enable Query Store for DB1 is the better option.

upvoted 0 times

...

Alpha

1 months ago

B) For DB1, set QUERY_CAPTURE_MODE of Query Store to All.

upvoted 0 times

...

Freida

1 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

...