The diagnostics log outputs tempDB contention details. You can use the information as the starting point for troubleshooting.
You can use the Intelligent Insights performance diagnostics log of Azure SQL Database to troubleshoot performance issues.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot- performance#tempdb-contention
https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log 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 D is Correct: Run dynamic management view-based queries 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. This fits the case because the requested outcome is: You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1. The selected feature addresses that outcome directly rather than relying on a workaround.
Why A 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.
Why B is Wrong: Review information provided by SQL Server Profiler-based traces 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.
Why C is Wrong: Query Performance Insight surfaces resource-consuming queries and database workload patterns in Azure SQL for performance investigation. 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.