A Data Engineer needs to configure a task in Snowflake to automatically send error notifications in case of a data loading failure. The Engineer wants to use an existing task that inserts data into…

Question

Options

• AAdd an ALERT clause in the task definition to link it to the notification service.
• BAdd the command: ALTER TASK MYTASK SET ERROR_INTEGRATION =
• CUse the parameter in the task
• DAdd NOTIFICATION_PROVIDER = 'my_notificacion_int' to the task schedule.

• A
  4% (1)
• B
  71% (17)
• C
  17% (4)
• D
  8% (2)

Explanation

Option B is correct because Snowflake tasks support an ERROR_INTEGRATION property that links a task to a pre-configured notification integration - in this case my_notification_int. The correct command is ALTER TASK MYTASK SET ERROR_INTEGRATION = 'my_notification_int', which tells Snowflake to automatically push error details to the SNS topic whenever the task fails.

Option A is wrong because Snowflake tasks have no ALERT clause; Snowflake Alerts are a separate, standalone object used for condition-based monitoring, not a clause you embed inside a task definition.

Option C is a distractor with no actual parameter named - the real parameter is ERROR_INTEGRATION, and it must be explicitly set via ALTER TASK, not just referenced generically "in the task."

Option D is wrong because NOTIFICATION_PROVIDER is not a valid Snowflake task parameter; error notification is wired through ERROR_INTEGRATION, not a provider name in the schedule block.

Memory tip: Think Error → Error_Integration. Whenever a Snowflake task fails and you need to notify an external service, you ALTER TASK ... SET ERROR_INTEGRATION = '<integration_name>' - the word "integration" links back to the notification integration object you created separately (e.g., with CREATE NOTIFICATION INTEGRATION).

No community discussion yet for this question.