[Reference:, https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-all-transact-sql?view=sql-server-ver15, , , , , , , Basic Concept: This question tests monitor, configure, and optimize database resources in the DP-300 exam context. The correct choice is determined by the exact service boundary and operational requirement stated in the scenario., Why A is Correct: Run the set showplan_all Transact-SQL statement. matches the expected DP-300 administration action. Run the set showplan_all Transact-SQL statement. is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: You need to display the estimated execution plan of a query by using the query editor in the Azure portal., Why B is Wrong: Query Store captures query text, plans, and runtime statistics, making it central for reviewing query history and troubleshooting plan regressions. It would produce a different operational signal than the one needed to investigate, alert, or tune the workload in this question., Why C is Wrong: Run the set forceplan Transact-SQL statement. is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It does not expose the required metric, query history, wait/blocking signal, or tuning mechanism; using it would not give the administrator the evidence requested., Why D is Wrong: Query Store captures query text, plans, and runtime statistics, making it central for reviewing query history and troubleshooting plan regressions. It is useful in other troubleshooting paths, but this scenario requires a more specific monitoring or optimization feature., ]