nerdexam
SnowflakeSnowflake

DEA-C02 · Question #79

DEA-C02 Question #79: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.

Snowflake Scripting and Tasks

Question

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 a table every 5 minutes. The Engineer set up a notification integration with Amazon Secure Notification Service (SNS) named my_notification_int. How should the task be updated to automatically send error notifications if it fails?

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.

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Tasks#Error Handling#Notification Integrations#ALTER TASK
Full DEA-C02 PracticeBrowse All DEA-C02 Questions