Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How does Snowflake optimize query performance by leveraging the sorted data and storage structure within micro-partitions?
A
The data is pruned by column to eliminate unnecessary micro-partitions, then the rows within the remaining micro-partitions are filtered.
B
The data is pruned by micro-partitions based on column values, then rows within the remaining micro-partitions are filtered.
C
Any micro-partitions that are not needed for the query are pruned, then the data within the remaining micro-partitions is pruned by column.
D
The data within micro-partitions is sorted by rows, then the columns are filtered based on the query conditions.
