DAA-C01 Question 254
Single answerConfigure subscriptions and updatesA retail analytics team uses Snowsight dashboards to monitor daily sales KPIs. Executives want to receive an emailed snapshot of a dashboard every weekday morning, and they also want the message to reflect the latest data from overnight loads. The analyst has already built the dashboard and verified that the underlying queries return current results after the ETL completes at 5:30 AM. What is the best approach to meet this requirement with the least operational overhead?
- A
Create a dashboard subscription in Snowsight, schedule it for weekdays after 5:30 AM, and send it to the executive recipients.
- B
Create an alert on the sales table so Snowflake emails the dashboard image to executives every weekday morning.
- C
Use a task to refresh the dashboard at 5:30 AM and attach the dashboard as an email attachment to the task notification.
- D
Share the dashboard URL with executives and rely on automatic browser refresh so they always see the latest data.
Show answer and explanation
Correct answer: A
Explanation
The correct solution is to use a Snowsight dashboard subscription. Subscriptions are intended for scheduled updates to dashboard consumers and are appropriate when stakeholders want recurring email delivery without manual intervention. To ensure recipients see current information, the analyst should schedule the subscription after the upstream ETL/load process completes. This aligns with Snowflake best practices: use dashboard subscriptions for periodic dashboard delivery, use alerts for conditional notifications based on query results, and use tasks for scheduled data processing rather than dashboard distribution.
- A. Correct.
Correct. Snowsight dashboard subscriptions are designed for scheduled delivery of dashboard snapshots to recipients. Scheduling the subscription after the overnight ETL ensures the emailed snapshot reflects the latest loaded data. This is the most direct and lowest-overhead way to distribute recurring dashboard updates to business users.
- B. Incorrect.
Incorrect. Alerts in Snowflake are used to evaluate a condition and trigger an action, such as sending a notification when query results meet criteria. They are not the feature used to schedule recurring dashboard snapshot emails to recipients. This option confuses data-condition monitoring with dashboard distribution.
- C. Incorrect.
Incorrect. Tasks can schedule SQL or procedural execution, but they do not natively 'refresh a dashboard' or send a Snowsight dashboard as an email attachment. Dashboards in Snowsight render current query results when viewed or when a subscription snapshot is generated. This option mixes task scheduling with dashboard delivery capabilities that are handled through subscriptions.
- D. Incorrect.
Incorrect. Sharing a URL may allow executives to open the dashboard manually, but it does not satisfy the requirement for an emailed snapshot delivered every weekday morning. Browser refresh behavior is also client-side and not a controlled distribution mechanism.