DP-300 Certification Practice Question #170

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)?

Accepted Answer

To compare two execution plans in SQL Server Management Studio (SSMS)—specifically comparing the previous actual plan (before adding the index) with the Live Query Statistics of the new query execution—you must first save the previous actual execution plan as an XML showplan file (`.sqlplan`) using Option C. Once saved, you can run the query again with Live Query Statistics enabled, right-click the execution plan, choose "Compare Showplan", and select the saved plan file to view the side-by-side comparison. Option D is incorrect because Query Store is already enabled by default in Azure SQL Database.

More DP-300 practice questions