SnowPro Core Certification — Question 125

As a best practice, clustering keys should only be defined on tables of which minimum size?

Answer options

• A. Multi-Kilobyte (KB) Range
• B. Multi-Megabyte (MB) Range
• C. Multi-Gigabyte (GB) Range
• D. Multi-Terabyte (TB) Range

Correct answer: D

Explanation

Clustering keys are most effective when applied to large datasets, which typically start at the Multi-Terabyte (TB) range. This allows for better data organization and retrieval performance. The other options (KB, MB, GB) are too small for the benefits of clustering keys to be realized.