Microsoft
DP-300 · Question #77
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…
The correct answer is A. Force the query execution plan for plan 1221065. As per exhibit, the execution plan 1221065 has lower execution time compared to plan 1220917. https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-store-usage-
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?
Exhibits
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.
How the community answered
(18 responses)- A83% (15)
- B11% (2)
- C6% (1)
Explanation
As per exhibit, the execution plan 1221065 has lower execution time compared to plan 1220917. https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-store-usage-
Community Discussion
No community discussion yet for this question.