Which object is not created for each Kafka topic by the Snowflake Kafka Connector?

• A. One internal stage to temporarily store data files for each topic
• B. One pipe to ingest the data files for each topic partition
• C. One table for each topic
• D. One external stage to temporarily store data files for each topic

Answer: (D)

This question tests how Snowflake's Kafka Connector handles staging and loading data from Kafka topics. The connector creates an internal stage within Snowflake for each topic to hold the data files temporarily as they are consumed. A pipe is then used to continuously load those staged files into a Snowflake table dedicated to that topic, enabling efficient, ongoing ingestion. A table per topic is created to organize and isolate the data coming from different topics, which keeps the data model clean and queryable by topic.

An external stage, which points to cloud storage outside Snowflake (like S3 or Azure Blob), is not created for each topic by the Kafka Connector. The typical ingestion flow relies on Snowflake-managed internal staging and pipes to move data into tables, so external stages aren’t part of this per-topic ingestion pattern.