Snowflake does not prune micro-partitions based on a predicate with a subquery

Snowflake does not prune micro-partitions based on a predicate with a subquery
A . TRUE
B. FALSE

View Answer

Answer: A

Explanation

Not all predicate expressions can be used to prune. For example, Snowflake does not prune micro-partitions based on a predicate with a subquery, even if the subquery results in a constant. Question 14:

Which of the below micro-partition metadata is maintained by snowflake