SnowPro Core Certification — Question 661

Which data types can be used in a Snowflake table that holds semi-structured data? (Choose two.)

Answer options

• A. ARRAY
• B. BINARY
• C. TEXT
• D. VARIANT
• E. VARCHAR

Correct answer: A, D

Explanation

ARRAY and VARIANT are specifically designed to handle semi-structured data in Snowflake, allowing for flexible data storage. The other options, BINARY, TEXT, and VARCHAR, are more suited for structured data types and do not provide the same level of flexibility for semi-structured formats.