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

Lashawn

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

...

Nichelle

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

...

Freida

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

...