Exam DEA-C02 Topic 1 Question 216 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 216
Topic #: 1

You are designing a Snowflake data pipeline that continuously ingests clickstream dat a. You need to monitor the pipeline for latency and throughput, and trigger notifications if these metrics fall outside acceptable ranges. Which of the following combinations of Snowflake features and techniques would be MOST effective for achieving this goal?

A. Use Snowflake's 'QUERY_HISTORY view to track query execution times and implement a scheduled task that queries this view, calculates latency and throughput, and sends email notifications using Snowflake's built-in email integration if thresholds are exceeded. B. Implement a combination of Snowflake Streams, Tasks, and external functions. Streams capture changes, Tasks process the changes, and external functions send notifications to a monitoring service when latency or throughput issues are detected. C. Rely on Snowflake's default resource monitors to track warehouse usage. If warehouse usage exceeds a certain threshold, assume there are performance issues and send a notification. D. Use Snowflake's Event Tables and Event Notifications to capture events related to data ingestion and processing. Configure alerts based on event patterns that indicate latency or throughput issues. E. Create a custom dashboard using a Bl tool that connects to Snowflake via JDBC/ODBC and visualizes data ingestion and processing metrics. Manually monitor the dashboard for anomalies.

Suggested Answer: B,D Vote an answer

Options B and D offer the most effective solutions. Option B provides a granular approach using Streams, Tasks, and external functions for real-time monitoring and notification. Option D leverages Event Tables and Event Notifications, enabling a reactive approach based on specific event patterns. Option A is less precise as it relies on query history, which may not accurately reflect real-time latency. Option C is too general. Option E requires manual monitoring, which is not ideal for continuous pipelines.

by Liz at Dec 02, 2025, 06:49 AM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business