SnowPro Core Certification — Question 287

What are value types that a VARIANT column can store? (Choose two.)

Answer options

• A. STRUCT
• B. OBJECT
• C. BINARY
• D. ARRAY
• E. CLOB

Correct answer: B, D

Explanation

The VARIANT column is designed to store semi-structured data, which includes OBJECT and ARRAY types. STRUCT and BINARY are not valid types for VARIANT columns, while CLOB is typically used for large text data, not for the VARIANT data type.