SnowPro Advanced: Data Engineer Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose D2

  With date columns set as clustering key there should come much performance as warehouse will scan just 1/(365*2) partitions for query that filters out records for one day instead of almost 100% scan

• Chose D1

  Here since, only data on a single date is needed, we don't need to scan all the table nor all micro-partitions. So adding a date column as a cluster key sound right.

• Chose D2

  although there are bytes spilling, but compare with the size, it is not much, so option B may improve, but not much. considering filter is on a single field, option D make sense.