Answer: ARRAY, VARIANT

The question asks for two data types used to store semi-structured data in Snowflake. According to Snowflake documentation and the community consensus (100% agreement on AE), ARRAY and VARIANT are the correct choices. ARRAY stores ordered collections of elements, while VARIANT can store any semi-structured data including arrays, objects, and nested structures. BLOB and CLOB are for binary and character large objects respectively, which are unstructured data types. JSON is a file format, not a native Snowflake data type for storing semi-structured data in tables.

Author: LeetQuiz Editorial Team