
Answer-first summary for fast verification
Answer: OBJECT, VARIANT
The question asks for the two native Snowflake data types used for storing semi-structured data. According to Snowflake documentation and the community discussion, Snowflake provides three native data types specifically for semi-structured data: ARRAY, OBJECT, and VARIANT. The VARIANT type can store any semi-structured data (including arrays and objects), while OBJECT is specifically for key-value pairs (like JSON objects). The community discussion confirms that OBJECT and VARIANT are correct answers, with 100% consensus on BE. Option A (NUMBER) is for numeric data, Option C (STRING) and Option D (VARCHAR) are for string data - all are structured data types, not specifically for semi-structured data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.