Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 11 Topic 2 Discussion

Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 11 Topic 2 Discussion

DEA-C01 Exam Topic 2 Question 11 Discussion:
Question #: 11
Topic #: 2

A Data Engineer is building a pipeline to transform a 1 TD tab e by joining it with supplemental tables The Engineer is applying filters and several aggregations leveraging Common TableExpressions (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?


A.

Enable clustering on the table


B.

Increase the warehouse size


C.

Rewrite the query to remove the CTEs.


D.

Switch to a multi-cluster virtual warehouse


Get Premium DEA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.