SnowPro Advanced Data Engineer Query Practice Questions

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?

• AA. Enable clustering on the table
• BB. Increase the warehouse size
• CC. Rewrite the query to remove the CTEs.
• DD. Switch to a multi-cluster virtual warehouse

A large table with 200 columns contains two years of historical data. When queried. the table is filtered on a single day Below is the Query Profile: Using a size 2XL virtual warehouse, this query look over an hour to complete What will improve the query performance the MOST?

• AA. increase the size of the virtual warehouse.
• BB. Increase the number of clusters in the virtual warehouse
• CC. Implement the search optimization service on the table
• DD. Add a date column as a cluster key on the table