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
D is correct
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
PrasantSadangi
4 days, 7 hours agoMallikharjuna452
8 months, 2 weeks agoMultiCloudIronMan
1 year, 8 months agoMayuri917233
1 year, 10 months agoBagvi
2 years agoabbcia
2 years agodatamech001
2 years, 5 months agoDK69
2 years, 10 months ago