Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
An electronics manufacturing company has recently launched their new smartphone in the market. The sales team is using a query to monitor daily sales across different stores. They aim to receive an email alert whenever the number of units sold increases by more than 1000 units for any store in a single day. Which of the following sequences correctly fills in the blanks to achieve this task?
An electronics manufacturing company has recently launched their new smartphone in the market. The sales team is using a query to monitor daily sales across different stores. They aim to receive an email alert whenever the number of units sold increases by more than 1000 units for any store in a single day. Which of the following sequences correctly fills in the blanks to achieve this task?
Explanation:
To monitor sales and receive alerts based on specific conditions, the correct sequence involves creating an SQL query to calculate total units sold, setting up an Alert with a trigger condition (total units sold > 1000), scheduling the Refresh to run daily, and adding the destination Email Address. Alerts are designed to notify when certain thresholds are met, complementing scheduled queries by checking criteria after every execution. This setup ensures the sales team is promptly informed of significant sales increases.