Answer-first summary for fast verification
Answer: To increase scan efficiency in queries by improving pruning
The correct answer is B because clustering in Snowflake primarily improves query performance by organizing data into micro-partitions based on clustering keys, which enables more efficient pruning during scans. This means Snowflake can skip irrelevant micro-partitions when executing queries, reducing the amount of data scanned. Option A is incorrect because clustering doesn't guarantee unique records - that's handled by primary keys or unique constraints. Option C is misleading as clustering doesn't create separate files specifically for point lookups; it optimizes scan efficiency. Option D is incorrect because clustering doesn't provide data redundancy - Snowflake's architecture already handles redundancy automatically through its multi-cluster shared data architecture.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a primary benefit of table clustering in Snowflake?
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
No comments yet.