MicrosoftMicrosoft
DP-300 · Question #167
DP-300 Question #167: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #167. The question stem and answer options stay visible for context.
Submitted by anna_se· Mar 6, 2026Optimize query performance
Question
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?
Options
- 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.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.