SnowPro Core Certification — Question 273

What data type should be used to store JSON data natively in Snowflake?

Answer options

• A. JSON
• B. String
• C. Object
• D. VARIANT

Correct answer: D

Explanation

The correct answer is VARIANT, as it is specifically designed to store semi-structured data types like JSON in Snowflake. The other options, such as JSON and Object, are not recognized data types in Snowflake, and String is not suitable for handling the complex structure of JSON data.