
Answer-first summary for fast verification
Answer: OBJECT, ARRAY
The question asks which two data types can be stored in a VARIANT column. According to Snowflake documentation and the community discussion consensus (with BD receiving 100% agreement and multiple comments confirming OBJECT and ARRAY), VARIANT can store semi-structured data types including OBJECT and ARRAY. The VARIANT data type is specifically designed to handle semi-structured data formats, making OBJECT and ARRAY the correct choices. While VARIANT can technically store other data types through internal conversion, the question specifically asks for data types that VARIANT can store, and OBJECT/ARRAY are the semi-structured types that align with VARIANT's primary purpose. Other options like STRUCT, BINARY, and CLOB are either not Snowflake data types or not the semi-structured types that VARIANT is optimized for.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.