SnowPro Core Certification — Question 246

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

Answer options

• A. VARIANT
• B. VARRAY
• C. STRUCT
• D. ARRAY
• E. QUEUE

Correct answer: A, D

Explanation

The correct options are VARIANT and ARRAY because Snowflake specifically supports these data types for handling semi-structured data. VARRAY, STRUCT, and QUEUE are not data types that are recognized for semi-structured data in Snowflake.