What should you do first?

You have an Azure SQL database named DB1.

You need to display the estimated execution plan of a query by using the query editor in the Azure portal.

What should you do first?
A . Run the set showplan_all Transact-SQL statement.
B. For DB1, set QUERY_CAPTURE_MODE of Query Store to All.
C. Run the set forceplan Transact-SQL statement.
D. Enable Query Store for DB1.

View Answer

Answer: A

Explanation:

Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-all-transact-sql?view=sql-server-ver15