Exam4Training

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

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

Latest DEA-C01 Dumps Valid Version with 100 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version