Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 41 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 41
Topic #: 1
[All 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?

  • A. They can set up an Alert with a custom template.
  • B. They can set up an Alert with a new email alert destination.
  • C. They can set up an Alert with a new webhook alert destination.
  • D. They can set up an Alert with one-time notifications.
  • E. They can set up an Alert without notifications.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
XiltroX
Highly Voted 1 year, 7 months ago
Selected Answer: C
Correct answer.
upvoted 5 times
...
AndreFR
Most Recent 11 months, 1 week ago
Selected Answer: 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.
upvoted 4 times
...
awofalus
1 year ago
Selected Answer: C
C is correct
upvoted 1 times
...
vctrhugo
1 year, 2 months ago
Selected Answer: 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.
upvoted 2 times
...
Atnafu
1 year, 4 months ago
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.
upvoted 3 times
...
4be8126
1 year, 7 months ago
Selected Answer: 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.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...