SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ28

Design and Manage Snowflake Resources and Performance

A Data Engineer is creating a pipeline that transforms a 1 TB table by joining it with supplemental tables. The Engineer applies filters and several aggregations using Common Table Expressions (CTEs) in a single Snowflake query on a Medium virtual warehouse.

After reviewing the Query Profile, which approach is recommended to MAXIMIZE this query’s performance if the profile shows data spillage?

Explanation

Data spillage occurs when intermediate query data exceeds the virtual warehouse’s available memory and local storage. Increasing the warehouse size increases those resources for the single query and is Snowflake’s recommended way to alleviate spilling and improve performance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!