Answer-first summary for fast verification
Answer: SQL, Alert, Refresh, email address
The correct answer is **SQL, Alert, Refresh, email address**. Here's why: 1. **Create a SQL query**: This query will calculate the total units sold. 2. **Setup an Alert**: This alert will monitor the query with the condition 'Units Sold > 10,000'. 3. **Setup Refresh**: The alert will be evaluated every 5 minutes. 4. **Add a destination email address**: This is where the alert notifications will be sent. This process aligns with Databricks documentation for setting up alerts on query results, ensuring the operations team is promptly notified of significant sales increases.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The operations team wants to monitor a recently launched product by setting up an email alert that triggers when the number of units sold increases by more than 10,000 units, with checks every 5 minutes. Complete the steps needed to achieve this by filling in the blanks:
· Create a ___ query that calculates total units sold · Setup a ____ with the query on the trigger condition 'Units Sold > 10,000' · Setup a ____ to run every 5 minutes · Add a destination ______
A
Python, Job, SQL Cluster, email address
B
SQL, Alert, Refresh, email address
C
SQL, Job, SQL Cluster, email address
D
SQL, Job, Refresh, email address
E
Python, Job, Refresh, email address
No comments yet.