Exam AZ-104 topic 6 question 54 discussion

The first one to comment

To be able to run queries and analyze log data for Azure SQL database DB1, you should configure the Diagnostic settings to send the logs to a Log Analytics workspace. A. Send to a Log Analytics workspace: This option allows you to send the diagnostic logs to a Log Analytics workspace, which serves as a central repository for log data. You can then run queries and perform analysis on the log data using Azure Monitor Logs.

A is correct

A is right

Data sent to a Log Analytics workspace can be consumed by SQL Analytics, which provides intelligent monitoring of your databases including performance reports, alerts, and mitigation recommendations. Moreover, data in a Log Analytics workspace can be analyzed alongside other monitoring data collected, and also allows you to leverage other Azure Monitor features such as alerts and visualizations https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql&tabs=azure-portal https://www.sqlservercentral.com/articles/monitoring-azure-sql-databases#:~:text=If%20not%2C%20just%20search%20for%20Log%20Analytics%20workspace,Set%20the%20destination%20to%20your%20Log%20Analytics%20Workspace.#:~:text=If%20not%2C%20just%20search%20for,to%20your%20Log%20Analytics%20Workspace https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-and-log-analytics-better-together-part-1/ba-p/794833