Answer: ARRAY, VARIANT

The question specifically asks for native data types that Snowflake provides for storing semi-structured data, not file formats. According to Snowflake documentation and the community discussion consensus (with 100% agreement on AE), Snowflake provides three native data types for semi-structured data: ARRAY, OBJECT, and VARIANT. Among the options, ARRAY (A) and VARIANT (E) are native data types, while JSON (B) is a file format, and ORC (C) and Parquet (D) are columnar file formats, not native data types. The community discussion clearly emphasizes this distinction between data types and file formats, with upvoted comments confirming that ARRAY and VARIANT are correct answers.

Author: LeetQuiz Editorial Team