SnowPro Core Certification — Question 746
Which data types can be used in Snowflake to store semi-structured data? (Choose two.)
Answer options
- A. ARRAY
- B. BLOB
- C. CLOB
- D. JSON
- E. VARIANT
Correct answer: A, E
Explanation
The correct answers are ARRAY and VARIANT, as these data types are specifically designed to handle semi-structured data in Snowflake. BLOB and CLOB are used for binary and character large objects, respectively, while JSON is a data format rather than a data type in Snowflake.