DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ17

VerifiedOfficial exam objectives/topics

A large, 200-column table holds two years of historical data. Queries filter the table to a single day. The Query Profile is shown below:

Question Image

Using a 2XL virtual warehouse, the table query required more than an hour to finish.

What change will improve query performance the MOST?

Explanation

A date clustering key groups rows into micro-partitions by the date used in the filter. This enables extensive micro-partition pruning, substantially reducing remote disk I/O and the amount of data scanned for a single-day query. Snowflake recommends clustering columns that are actively used in selective filters, specifically noting date columns for date-based fact-table queries.

Learn more

Community Discussion

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