Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming- export-configure?tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry Basic Concept: This question tests Azure monitoring and performance management, including which metric, log destination, or alerting behavior fits the operational requirement.
Why D is Correct: Azure SQL Analytics alerts based on diagnostics logs 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. In this scenario, the important constraint is: You need to configure alerts for each database based on the diagnostics telemetry of the database. Azure SQL Analytics alerts based on diagnostics logs satisfies that constraint without adding an unrelated service or manual process.
Why A is Wrong: Azure SQL Analytics alerts based on metrics 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 B is Wrong: SQL Health Check alerts based on diagnostics logs 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: SQL Health Check alerts based on metrics 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.