SnowPro Core Certification — Question 422

Which semi-structured data formats can be loaded into Snowflake with a COPY command? (Choose two.)

Answer options

• A. CSV
• B. EDI
• C. HTML
• D. ORC
• E. XML

Correct answer: D, E

Explanation

The correct answers are D and E because ORC and XML are both recognized as semi-structured data formats that can be ingested using the COPY command in Snowflake. In contrast, CSV is a structured format, and EDI and HTML do not fit into the semi-structured category supported by Snowflake's COPY command.