Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam
Go to Exam
Question 41

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.

Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?

    Correct Answer: C

    To notify the entire team via a messaging webhook when the number of NULL values reaches 100, the data engineer can set up an Alert with a new webhook alert destination. By configuring the alert to trigger when the specified condition is met and providing the URL for the messaging webhook, notifications will be sent to the team's messaging service once the threshold is reached.

Discussion
XiltroXOption: C

Correct answer.

4be8126Option: C

The approach the data engineer can use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100 is: C. They can set up an Alert with a new webhook alert destination. Explanation: To achieve this, the data engineer can set up an Alert in the Databricks workspace that triggers when the query results exceed the threshold of 100 NULL values. They can create a new webhook alert destination in the Alert's configuration settings and provide the necessary messaging webhook URL to receive notifications. When the Alert is triggered, it will send a message to the configured webhook URL, which will then notify the entire team of the issue.

AndreFROption: C

https://docs.databricks.com/en/lakehouse-monitoring/monitor-alerts.html Monitor alerts are created and used the same way as other Databricks SQL alerts. You create a Databricks SQL query on the monitor profile metrics table or drift metrics table. You then create a Databricks SQL alert for this query. You can configure the alert to evaluate the query at a desired frequency, and send a notification if the alert is triggered. By default, email notification is sent. You can also set up a webhook or send notifications to other applications such as Slack or Pagerduty.

vctrhugoOption: C

C. They can set up an Alert with a new webhook alert destination. To notify their entire team via a messaging webhook whenever the number of NULL values reaches 100, the data engineer can set up an Alert in Databricks with a new webhook alert destination. This allows them to configure the alert to trigger when the specified condition (reaching 100 NULL values) is met, and the notification can be sent to the team's messaging webhook. Option C provides the specific approach to achieve the desired outcome of notifying the team via a messaging webhook when the condition is met.

AtnafuOption: C

C Alerts allow you to be notified when something goes wrong in your Databricks environment. You can set up alerts to be notified by email, webhook, or Slack. Webhooks are a way to send data from one application to another. You can use a webhook to send data from Databricks to a messaging service, such as Slack or PagerDuty. One-time notifications allow you to be notified only once when an alert is triggered. This is useful if you only want to be notified about a specific event. Custom templates allow you to customize the email or webhook notification that is sent when an alert is triggered. This is useful if you want to include additional information in the notification, such as the name of the alert or the value of the metric that triggered the alert.

awofalusOption: C

C is correct