SnowPro Core Certification — Question 256

Which data types does Snowflake support when querying semi-structured data? (Choose two.)

Answer options

• A. VARIANT
• B. VARCHAR
• C. XML
• D. ARRAY
• E. BLOB

Correct answer: A, D

Explanation

The correct choices are VARIANT and ARRAY, as they are specifically designed to handle semi-structured data in Snowflake. VARCHAR is for structured text data, XML is not directly supported as a data type in Snowflake, and BLOB is used for binary data, which does not fit the semi-structured category.