Answer: VARIANT

The correct answer is D (VARIANT) because Snowflake does not have a dedicated 'JSON' data type. According to Snowflake documentation and the overwhelming community consensus (98% of users selected D), the VARIANT data type is specifically designed to store semi-structured data like JSON natively. Option A (JSON) is incorrect as no such data type exists in Snowflake. Option B (String) would store JSON as plain text but not natively, losing the ability to query JSON elements efficiently. Option C (Object) refers to a specific semi-structured type for key-value pairs but is not the primary type for storing arbitrary JSON data; VARIANT is more versatile for this purpose.

Author: LeetQuiz Editorial Team