Home » Microsoft » DP-201 v.2 » Which destination should you include in the recommendation?
You are designing an audit strategy for an Azure SQL Database environment.
You need to recommend a solution to provide real-time notifications for potential security breaches. The solution must minimize development effort.
Which destination should you include in the recommendation?
A. Azure Blob storage
B. Azure Synapse Analytics
C. Azure Event Hubs
D. Azure Log Analytics
Correct Answer: D
Explanation/Reference:
Explanation:
Auditing for Azure SQL Database and Synapse Analytics tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace or Event Hubs.
Alerts in Azure Monitor can identify important information in your Log Analytics repository. They are created by alert rules that automatically run log searches at regular intervals, and if results of the log search match particular criteria, then an alert record is created and it can be configured to perform an automated response.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing
https://docs.microsoft.com/en-us/azure/azure-monitor/learn/tutorial-response