Basic Concept: This question tests performance optimization for SQL workloads, including Query Store, automatic tuning, index/statistics maintenance, and engine-level resource behavior.
Why D is Correct: Enable automatic tuning for db1. matches the expected DP-300 administration action.
Automatic tuning uses built-in recommendations and verification to create/drop indexes or force last known good plans where supported. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.
Why A is Wrong: The vCore purchasing model separates compute and storage sizing and supports Azure Hybrid Benefit for eligible SQL Server licenses. 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 B is Wrong: Disable auto-pause delay for dbl. 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.
Why C is Wrong: Decrease the auto-pause delay for db1. 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 would produce a different operational signal than the one needed to investigate, alert, or tune the workload in this question.