
Answer-first summary for fast verification
Answer: JSON, Avro, Parquet
The correct answers are B (JSON), D (Avro), and E (Parquet). According to Snowflake documentation and the community discussion consensus (100% agreement with BDE), Snowflake supports loading semi-structured data from JSON, Avro, ORC, Parquet, and XML formats. These formats can be stored in Snowflake's specialized semi-structured data types like VARIANT, ARRAY, and OBJECT. TSV (A) is a structured tabular format, PDF (C) is a document format not directly supported for semi-structured data loading, and JPEG (F) is an image format, making them unsuitable for this purpose.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.