Exam DEA-C02 Topic 1 Question 250 Discussion

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

Consider a scenario where you're optimizing a data pipeline in Snowflake responsible for aggregating sales data from multiple regions. You've identified that the frequent full refreshes of the target aggregated table are causing significant performance overhead and resource consumption. Which strategies could be employed to optimize these full refreshes without sacrificing data accuracy?

A. Implement incremental data loading using streams and tasks. This allows you to only process and load the changes that have occurred since the last refresh, reducing the amount of data that needs to be processed. B. Replace the full refresh with a 'TRUNCATE TABLE' followed by an 'INSERT statement. This approach is faster than 'CREATE OR REPLACE TABLE' and reduces locking. C. Utilize Snowflake's Time Travel feature to clone the previous version of the aggregated table, apply the necessary changes to the clone, and then swap the clone with the original table using 'ALTER TABLE SWAP WITH'. Note that this will impact data availability during the swap operation. D. Schedule the full refreshes during off-peak hours when the Snowflake warehouse is less utilized. This minimizes the impact on other workloads but does not reduce the actual processing time. E. Leverage Snowflake's search optimization service on the base tables. While costly, this will dramatically speed up full table scans performed in the aggregation.

Suggested Answer: A,C Vote an answer

Options A and C are the most effective strategies. Incremental data loading (Option A) focuses on processing only the changed data, significantly reducing the processing time and resources used. Cloning and swapping (Option C) can provide a faster refresh while maintaining data availability (with a brief interruption during the swap). Option B, while faster than 'CREATE OR REPLACE TABLE, is still a full refresh and inefficient. Option D only mitigates the impact, not the underlying inefficiency. Option E will help improve performance but can be costly, should only be implemented for specific columns/tables and does not reduce the need for optimizing the data pipeline's refresh strategy directly.

by Emily at Aug 11, 2026, 11:26 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