Basic Concept: This question tests performance optimization for SQL workloads, including Query Store, automatic tuning, index/statistics maintenance, and engine-level resource behavior.
Why A is Correct: full matches the expected DP-300 administration action. full 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 plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image You need to register the SQL Server laaS Agent extension (SqllaasExtension).
Why B is Wrong: lightweight 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 C is Wrong: NoAgent 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 is useful in other troubleshooting paths, but this scenario requires a more specific monitoring or optimization feature.