SnowPro Core Certification — Question 975

Which Snowflake data type is used to store JSON key value pairs?

Answer options

• A. TEXT
• B. BINARY
• C. STRING
• D. VARIANT

Correct answer: D

Explanation

The VARIANT data type in Snowflake is specifically designed to hold semi-structured data, including JSON key-value pairs. The other options, such as TEXT, BINARY, and STRING, are not optimized for handling JSON structures, making VARIANT the correct choice.