Snowpro Core · Free Practice Question Medium
Question 65
The closer the ratio of scanned micro-partitions and columnar data is to the ratio of actual data selected, the more efficient is the pruning performed on the table. (TRUE/FALSE)
- A TRUE
- B FALSE
Reveal correct answer
Correct answer: A
Explanation
Snowflake uses columnar scanning of partitions so that an entire partition is not scanned if a query only filters by one column. The closer the ratio of scanned micro-partitions and columnar data is to the ratio of actual data selected, the more efficient is the pruning performed on the tableDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
