Snowpro Advanced Architect · Free Practice Question Medium
Question 5
- A CSV
- B Avro
- C JSON
- D Parquet
- E XML
Reveal correct answers
Correct answers: B, C
Explanation
✅ Avro
✅ JSON
Explanation:
The Snowflake Connector for Kafka supports Avro and JSON as message formats when ingesting data from Kafka topics into Snowflake.
Avro → A compact, binary format that is widely used for efficient serialization in Kafka.
JSON → A flexible, human-readable format that is commonly used for semi-structured data ingestion.
For more details, check the official Snowflake documentation on Kafka Connector .
❌ Why the other options are incorrect?
CSV
→ Incorrect, because CSV is not natively supported by the Snowflake Kafka Connector.
XML
→ Incorrect, because XML is not a standard format for Kafka ingestion into Snowflake.
Parquet
→ Incorrect, because Parquet is a columnar storage format, but not directly supported for Kafka ingestion into Snowflake.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
