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?

The correct answer is A. Run the SET SHOWPLAN_ALL Transact-SQL statement. The SET SHOWPLAN_ALL command causes Microsoft SQL Server not to execute Transact- SQL statements. Instead, SQL Server returns detailed information about how the statements are executed and provides estimates of the resource requirements for the statements…

Submitted by anna_se· Mar 6, 2026Optimize query performance

Question

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?

Options

ARun the SET SHOWPLAN_ALL Transact-SQL statement.
BFor DB1, set QUERY_CAPTURE_MODE of Query Store to All.
CRun the SET FORCEPLAN Transact-SQL statement.
DEnable Query Store for DB1.

How the community answered

(26 responses)

A
92% (24)
C
4% (1)
D
4% (1)

Explanation

The SET SHOWPLAN_ALL command causes Microsoft SQL Server not to execute Transact- SQL statements. Instead, SQL Server returns detailed information about how the statements are executed and provides estimates of the resource requirements for the statements. https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-all-transact-sql?view=sql-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice