DAA-C01 Question 255
Select 2Configure subscriptions and updatesA data analyst maintains a Snowsight dashboard used by regional sales managers. The dashboard should be delivered automatically every Monday at 7:00 AM in each recipient's local time, and managers should receive an additional alert email whenever weekly revenue drops below a defined threshold. The analyst wants to use built-in Snowsight capabilities with minimal custom development. Which TWO actions should the analyst take?
- A
Create a dashboard subscription for the sales managers and configure the schedule with time zone-aware delivery settings.
- B
Configure a dashboard alert on the revenue tile so recipients are notified when the monitored value crosses the specified threshold.
- C
Create a Snowflake task that exports the dashboard as a file and emails it through an external notification integration, because Snowsight cannot send scheduled dashboard emails.
- D
Set up a materialized view on the revenue data so Snowsight can automatically notify users when the materialized view refresh detects lower values.
- E
Grant managers OWNERSHIP on the dashboard so they can receive scheduled deliveries and threshold-based notifications.
Show answer and explanation
Correct answers: A, B
Explanation
The best solution is to use two native Snowsight features together: dashboard subscriptions for scheduled delivery and dashboard alerts for threshold-based notifications. This matches the requirement for both recurring updates and exception-driven updates without building custom orchestration. In Snowflake best practice, subscriptions are used when stakeholders need a regular snapshot of dashboard results, while alerts are used when they need to be notified only when a monitored metric crosses a condition. Custom tasks, external email integrations, or privileged object ownership are not required when the built-in Snowsight dashboard delivery and alerting features satisfy the business need.
- A. Correct.
Correct. Snowsight supports dashboard subscriptions so users can receive scheduled dashboard snapshots by email. Scheduling can be configured for recurring delivery, and using the appropriate time zone settings aligns delivery with recipients' local business hours. This is the built-in feature intended for periodic dashboard distribution.
- B. Correct.
Correct. Snowsight supports alerts on dashboard tiles so users can be notified when a metric meets a defined condition, such as revenue falling below a threshold. This addresses the requirement for event-driven updates in addition to the regular subscription schedule.
- C. Incorrect.
Incorrect. This option describes a custom workaround, but the scenario specifically asks for built-in Snowsight capabilities with minimal custom development. Snowsight dashboard subscriptions already provide scheduled email delivery, so building a task-based export and external email workflow is unnecessary for this requirement.
- D. Incorrect.
Incorrect. Materialized views improve query performance for some workloads, but they do not provide user-facing subscription or alerting behavior in Snowsight. Refresh activity in a materialized view is not a notification mechanism for dashboard consumers.
- E. Incorrect.
Incorrect. Recipients do not need OWNERSHIP on a dashboard to receive subscriptions or alerts. OWNERSHIP is excessive and violates least-privilege principles. Appropriate access to the underlying dashboard and data is required, but administrative ownership is not the mechanism that enables scheduled deliveries or alerts.