DP-300 Certification Practice Question #168

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?

Accepted Answer

The Query Store plan summary chart for query 1178902 displays execution duration (in milliseconds) on the y-axis (Total) and shows two execution plans: Plan 1220917 (pink dots) and Plan 1221065 (green dot). Plan 1221065 exhibits a much lower execution duration (close to 0 ms) compared to Plan 1220917 (which is over 200,000 ms). To optimize query performance and ensure the fastest execution, you should force Plan 1221065 (Option A). Force options are executed within Query Store, providing plan stability.

More DP-300 practice questions