SnowPro Core Certification — Question 428
Which data types are valid in Snowflake? (Choose two.)
Answer options
- A. BLOB
- B. Geography
- C. JSON
- D. CLOB
- E. Variant
Correct answer: B, E
Explanation
The correct answers are Geography and Variant, as these data types are specifically supported in Snowflake for handling geographical data and semi-structured data, respectively. BLOB and CLOB are not valid in Snowflake, and while JSON is a supported format, it is not categorized as a distinct data type in the same way as Geography and Variant.