Question 150
Consider this Snowflake situation: A large fact-table filter scans most micro-partitions because rows were loaded in a layout poorly correlated with the filter column. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: Micro-partition metadata enables pruning when values are localized enough to skip irrelevant partitions. It supports the response: Inspect pruning and clustering information before considering a clustering key on the frequently selective filter. Confirm it with this observable result: A representative filtered query scans fewer partitions after an appropriate clustering improvement. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
The offered statement is true for this other mechanism: Hybrid tables have transaction-oriented characteristics distinct from conventional analytic tables. It does not explain the facts described here, which follow from: Micro-partition metadata enables pruning when values are localized enough to skip irrelevant partitions.
This principle describes a separate cause: Snowflake manages compressed columnar storage and micro-partition metadata rather than exposing its managed files as editable customer objects. The reported condition is governed by: Micro-partition metadata enables pruning when values are localized enough to skip irrelevant partitions. The two mechanisms should not be conflated.
The offered statement is true for this other mechanism: Multi-cluster scaling policies trade responsiveness of adding clusters against compute spend. It does not explain the facts described here, which follow from: Micro-partition metadata enables pruning when values are localized enough to skip irrelevant partitions.