Answer: Clustering keys

The correct answer is B (Clustering keys) because clustering keys in Snowflake organize data in micro-partitions based on specified columns, which significantly improves query performance on very large tables by enabling efficient pruning of irrelevant data during query execution. This reduces the amount of data scanned and speeds up query processing. While other options like indexing (A) is not a native Snowflake feature (Snowflake uses automatic micro-partitioning instead), multi-clustering (C) is not a standard Snowflake term, and materialized views (D) can improve performance but are more specific for pre-computed results rather than general large table optimization. The community discussion shows 100% consensus on answer B with upvoted confirmations.

Author: LeetQuiz Editorial Team