SnowPro Core Certification — Question 26

What is the recommended Snowflake data type to store semi-structured data like JSON?

Answer options

• A. VARCHAR
• B. RAW
• C. LOB
• D. VARIANT

Correct answer: D

Explanation

The VARIANT data type in Snowflake is specifically designed to handle semi-structured data including JSON, making it the most suitable choice. VARCHAR is intended for plain text, RAW is not applicable, and LOB is used for large objects, which are not ideal for JSON.