Answer: ORC, XML

The question asks which semi-structured data formats can be loaded into Snowflake using the COPY command, requiring selection of two options. According to Snowflake documentation and the community discussion with 100% consensus on DE, Snowflake provides built-in support for loading semi-structured data formats including ORC (D) and XML (E). CSV (A) is a structured format, not semi-structured. EDI (B) is not natively supported as a semi-structured format in Snowflake. HTML (C) is also not a supported semi-structured data format for direct loading via COPY command. The community discussion references official Snowflake documentation confirming that ORC and XML are among the supported semi-structured formats.

Author: LeetQuiz Editorial Team