Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 870

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

    Correct Answer: C

    Query pruning is a mechanism Snowflake uses to limit the number of micro-partitions scanned by a query. It works by eliminating micro-partitions that cannot possibly contain the data being queried based on metadata, thereby making the query process more efficient.

Discussion
HeetecOption: C

C correct - https://blog.devgenius.io/snowflake-micro-partitions-clustering-keys-dbt-b6cb1212dcbe