nerdexam
Microsoft

DP-300 · Question #78

You have an Azure SQL database named DB1. You run a query while connected to DB1. You review the actual execution plan for the query, and you add an index to a table referenced by the query. You need

The correct answer is C. Save the actual execution plan.. The Plan Comparison menu option allows side-by-side comparison of two different execution plans, for easier identification of similarities and changes that explain the different behaviors for all the reasons stated above. This option can compare between: Two previously saved exec

Submitted by tom_us· Mar 6, 2026Optimize query performance

Question

You have an Azure SQL database named DB1. You run a query while connected to DB1. You review the actual execution plan for the query, and you add an index to a table referenced by the query. You need to compare the previous actual execution plan for the query to the Live Query Statistics. What should you do first in Microsoft SQL Server Management Studio (SSMS)?

Options

  • AFor DB1, set QUERY_CAPTURE_MODE of Query Store to All.
  • BRun the SET SHOWPLAN_ALL Transact-SQL statement.
  • CSave the actual execution plan.
  • DEnable Query Store for DB1.

How the community answered

(26 responses)
  • A
    15% (4)
  • B
    8% (2)
  • C
    73% (19)
  • D
    4% (1)

Explanation

The Plan Comparison menu option allows side-by-side comparison of two different execution plans, for easier identification of similarities and changes that explain the different behaviors for all the reasons stated above. This option can compare between: Two previously saved execution plan files (.sqlplan extension). One active execution plan and one previously saved query execution plan. Two selected query plans in Query Store.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice