Answer: VARIANT

The VARIANT data type in Snowflake is specifically designed to store semi-structured data formats including JSON, which consists of key-value pairs. According to Snowflake documentation and the community discussion with 100% consensus, VARIANT can contain key-value pairs and is the appropriate data type for JSON storage. Other options are less suitable: TEXT and STRING would store JSON as plain text without the ability to query individual key-value pairs efficiently, while BINARY is for binary data and not optimized for JSON key-value pair storage.

Author: LeetQuiz Editorial Team