MicrosoftMicrosoft
DP-300 · Question #77
DP-300 Question #77: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #77. The question stem and answer options stay visible for context.
Submitted by anna_se· Mar 6, 2026Optimize query performance
Question
You have SQL Server on an Azure virtual machine that contains a database named DB1. You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit: What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
Options
- AForce the query execution plan for plan 1221065.
- BRun the DBCC FREEPROCCACHE command.
- CForce the query execution plan for plan 1220917.
- DDisable parameter sniffing.
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.