SnowPro Core Certification — Question 374

What is a core benefit of clustering?

Answer options

• A. To guarantee uniquely identifiable records in the database
• B. To increase scan efficiency in queries by improving pruning
• C. To improve performance by creating a separate file for point lookups
• D. To provide data redundancy by duplicating micro-partitions

Correct answer: B

Explanation

The correct answer, B, highlights how clustering can optimize the efficiency of scans in queries, particularly through improved pruning techniques. Options A and C focus on aspects unrelated to clustering benefits, while D addresses data redundancy, which is not a primary goal of clustering.