To experience benefits from clustering, table data must be in which size range?

• A. KB
• B. MB
• C. GB
• D. TB

Answer: (D)

Clustering pays off when you have a lot of data, because it helps Snowflake prune more data that doesn’t match your filters. Each table is stored in many micro-partitions, and the bigger the table, the more partitions there are. If the data is organized by clustering keys, queries that filter on those keys can skip huge numbers of partitions, reducing I/O and speeding up results. When the dataset is small, the potential savings are minor and the overhead of maintaining clustering can outweigh any gains. With data at the terabyte scale, the reduction in scanned data becomes substantial, so you’re likely to see meaningful performance improvements. That’s why terabytes of data are the range where clustering starts to show clear benefits.