DP-300 Certification Practice Question #178

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?

Accepted Answer

In the Azure portal query editor, which is a web-based client without the rich graphical capabilities of SSMS, you can retrieve the estimated execution plan of a query by running the `SET SHOWPLAN_ALL ON;` Transact-SQL statement (Option A) in the query window before running the query. This command instructs the SQL engine to generate and return execution plan metadata for the subsequent queries in the batch without actually executing them. Options B, C, and D do not return estimated execution plans.

More DP-300 practice questions