Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Databricks Certified Data Engineer Associate Exam - Topic 1 Question 62 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate exam
Question #: 62
Topic #: 1
[All Databricks Certified Data Engineer Associate Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

A webhook alert destination is a way to send notifications to external applications or services via HTTP requests. A data engineer can use a webhook alert destination to notify their entire team via a messaging webhook, such as Slack or Microsoft Teams, whenever the number of NULL values in the input data reaches 100. To set up a webhook alert destination, the data engineer needs to do the following steps:

In the Databricks SQL workspace, navigate to the Settings gear icon and select SQL Admin Console.

Click Alert Destinations and click Add New Alert Destination.

Select Webhook and enter the webhook URL and the optional custom template for the notification message.

Click Create to save the webhook alert destination.

In the Databricks SQL editor, create or open the query that returns the number of input records containing unexpected NULL values.

Click the Create Alert icon above the editor window and configure the alert criteria, such as the value column, the condition, and the threshold.

In the Notification section, select the webhook alert destination that was created earlier and click Create Alert.Reference:What are Databricks SQL alerts?,Monitor alerts,Monitoring Your Business with Alerts,Using Automation Runbook Webhooks To Alert on Databricks Status Updates.


Contribute your Thoughts:

0/2000 characters
Romana
19 hours ago
I think we practiced a similar question where we had to choose between email and webhook notifications. Webhook seems more appropriate here.
upvoted 0 times
...
Terry
6 days ago
I remember we talked about setting up alerts in Databricks, but I'm not sure if a custom template is necessary for this.
upvoted 0 times
...

Save Cancel