Azure Synapse Diagnostic Settings for Custom Alerts

You have an Azure subscription that contains an Azure Synapse workspace named WS1 and an Azure Monitor action group named Group1. WS1 has a dedicated SQL pool. You plan to archive monitoring data for integration activity runs. You need to ensure that you can configure custom alerts based on the archived data that will execute Group1. The solution must minimize administrative effort. Which diagnostic setting should you select?

  1. Send to Log Analytics workspace Source Reference Answer
  2. Archive to a storage account
  3. Stream to an event hub
  4. Send to a partner solution

Community Votes

A
100%

100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

Tests the specific destination required for Azure Monitor custom alerts; the trap is choosing storage archiving which lacks native query/alerting capabilities without additional processing.

To configure custom alerts on archived integration activity data in Azure Synapse with minimal effort, send diagnostic logs to a Log Analytics workspace. This is the standard method for enabling Azure Monitor alert rules.

Candidates often select 'Archive to a storage account' because the question mentions 'archive', but this option does not support direct alert configuration via Azure Monitor.

Community Discussion (4 comments)

evangelist 👍 1 Selected: A
no doubt A
weyiyaw474 👍 1 Selected: A
Send to Log Analytics workspace
Lewiasskick 👍 1
https://learn.microsoft.com/en-us/azure/sentinel/detect-threats-custom
jongert 👍 2
Correct

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Sending diagnostic settings to a Log Analytics workspace allows you to run Kusto Query Language (KQL) queries on the data immediately. Azure Monitor custom alerts are natively built on top of Log Analytics workspaces, enabling you to define alert rules based on specific conditions in the integration activity runs.

Why the Other Options Are Wrong

Archiving to a storage account (Option B) is suitable for long-term retention but requires complex logic (like Azure Functions or Data Factory) to process and alert on data. Streaming to an Event Hub (Option C) is for real-time event ingestion by other services, not for direct alerting. Partner solutions (Option D) vary in capability and do not guarantee native Azure Monitor alert integration.

Community Comment Notes

The community consensus strongly supports Option A, noting that it is the only path to native alerting. Comments confirm that while 'archive' implies storage, the requirement for 'custom alerts' dictates Log Analytics.

Official Reference

Array

Exam Strategy

When a question asks for 'alerts' or 'monitoring' alongside 'diagnostic settings', prioritize Log Analytics Workspace unless specified otherwise. Do not be misled by keywords like 'archive' if the primary goal is active monitoring or alerting.

Related Analysis

← Back to DP-203 Study Guide