Which of the following is NOT automatically created by the Kafka connector for each topic?

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

Answer: (A)

The mechanism tested here is how Snowflake’s Kafka Connector manages data staging and loading from Kafka. The connector uses Snowflake-native objects to move data: it creates an internal stage for storing files derived from the Kafka topic, a loading pipe that ingests those files, and a dedicated table that represents the topic. This setup enables reliable, per-topic and per-partition parallel ingestion—files from each partition are staged and then loaded into the corresponding topic’s table via its pipe.

An external stage, which points to an external storage location like S3 or Azure, is not created automatically by the connector. External stages are optional and would require separate setup and configuration if you want to use external storage instead of Snowflake’s internal staging.