A web application hosted in Azure App Service stores its data in an Azure SQL Database. You must generate an alert when the database has 10,000 concurrent connections with minimal development effort. Which Diagnostics setting for the database should you select?
Choose an answer
Tap an option to check your answer.
Correct answer: Send to Log Analytics.
Why this is the answer
Sending diagnostic settings to Log Analytics allows you to collect and analyze various metrics and logs, including connection metrics for Azure SQL Database. Once the data is in Log Analytics, you can easily create custom alert rules based on specific thresholds, such as 10,000 concurrent connections, using Kusto Query Language (KQL). This approach requires minimal development effort as it leverages built-in Azure monitoring capabilities. Streaming to an event hub is suitable for real-time processing by external systems but requires additional development to consume and analyze the data for alerting. Archiving to a storage account is primarily for long-term retention and auditing, not for real-time alerting.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed