Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.