What are value types that a VARIANT column can store? (Select TWO)

What are value types that a VARIANT column can store? (Select TWO)
A . STRUCT
B . OBJECT
C . BINARY
D . ARRAY
E . CLOB

View Answer

Answer: B, D

Explanation:

A VARIANT column in Snowflake can store semi-structured data types.

This includes:

B. OBJECT: An object is a collection of key-value pairs in JSON, and a VARIANT column can store this type of data structure.

D. ARRAY: An array is an ordered list of zero or more values, which can be of any variant-supported data type, including objects or other arrays.

The VARIANT data type is specifically designed to handle semi-structured data like JSON, Avro, ORC, Parquet, or XML, allowing for the storage of nested and complex data structures.

Reference: Snowflake Documentation on Semi-Structured Data Types SnowPro® Core Certification Study Guide