COF-C02 Question 169

Community Discussion

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

• Chose D1

  Considerations for Choosing Clustering for a Table Whether you want faster response times or lower overall costs, clustering is best for a table that meets all of the following criteria: The table contains a large number of micro-partitions. Typically, this means that the table contains multiple terabytes (TB) of data. The queries can take advantage of clustering. Typically, this means that one or both of the following are true: The queries are selective. In other words, the queries need to read only a small percentage of rows (and thus usually a small percentage of micro-partitions) in the table. The queries sort the data. (For example, the query contains an ORDER BY clause on the table.) https://docs.snowflake.com/en/user-guide/tables-clustering-keys

• 1

  D.is correct

• Chose D1

  correct