Cloud services can help in pruning even if the columns are variant columns.

Cloud services can help in pruning even if the columns are variant columns.
A . TRUE
B. FALSE

Answer: A

Explanation:

Snowflake stores internally variant (json) data, in a independent column like structure for the 100+ most common elements, and the remainder in a leftovers like column. Those virtual columns have min/max, distribution like stats like normal columns have. So, even for variant columns, snowflake can use metadata repository for query pruning.

Latest ARA-C01 Dumps Valid Version with 156 Q&As

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

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments