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

Contribute your Thoughts:

Submit Cancel

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

...

10 days ago

I agree with An. Enabling Query Store will allow us to capture the execution plan.

upvoted 0 times

...

16 days ago

I think the first thing to do is to enable Query Store for DB1.

upvoted 0 times

...