Reference:
https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce-allocation- contention Basic Concept: This question tests database auditing and query visibility. DP-300 expects you to distinguish between collecting audit events, retaining logs, and analyzing query behavior.
Why B is Correct: No is correct because it is the feature whose normal purpose matches the stated requirement. No 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 scenario wording points to that specific behavior: Each question in the series contains a unique solution that might meet the stated goals.
Why A is Wrong: Yes 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.