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

1 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

17 days ago

I agree, using Query Store simplifies the process. No need to complicate things with Transact-SQL statements.

upvoted 0 times

...

Aleisha

21 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

23 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

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

13 days ago

Let's go with option D and enable Query Store for DB1.

upvoted 0 times

...

Viola

22 days ago

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

upvoted 0 times

...

Hillary

1 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

2 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

10 days ago

User3: D) Enable Query Store for DB1.

upvoted 0 times

...

Dulce

19 days ago

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

upvoted 0 times

...

Catalina

1 months ago

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

upvoted 0 times

...

Nichelle

2 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

17 days ago

Agreed, let's go with enabling Query Store for DB1.

upvoted 0 times

...

Annice

21 days ago

D) Enable Query Store for DB1.

upvoted 0 times

...

Lilli

23 days ago

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

upvoted 0 times

...

Alpha

2 months ago

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

upvoted 0 times

...

Freida

2 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

...