Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam
Go to Exam
Question 55

A Data Engineer is building a pipeline to transform a 1 TB table by joining it with supplemental tables. The Engineer is applying filters and several aggregations leveraging Common Table Expressions (CTEs) using a size Medium virtual warehouse in a single query in Snowflake.

After checking the Query Profile, what is the recommended approach to MAXIMIZE performance of this query if the Profile shows data spillage?

    Correct Answer: B

    To maximize the performance of the query in Snowflake when there's data spillage, the best approach is to increase the warehouse size. A larger warehouse can provide more computational resources, including CPU and memory, which helps manage and process large datasets more efficiently, reducing the chances of data spillage.

Discussion
stopthisnowOption: B

B makes sense