Question 270
An analytics engineering team reports this behavior: A team subscribes to a Kafka topic but deploys a generic script that repeatedly downloads a file snapshot instead of consuming record events. After the correction, which result provides the strongest evidence of success?
Explanation
Correct Answer
This verifies kafka connector mode because the ingestion design does not use a suitable Kafka-to-Snowflake streaming integration. The corresponding corrective action is: Configure the supported Snowflake Connector for Kafka and its streaming ingestion path. A green status for a different component would not independently establish this result.
Incorrect Answers
Automated event ingestion generally handles new notifications rather than all historical files by default. “Run a controlled historical load or supported pipe refresh mechanism for existing eligible files” would address that alternative cause, not the condition in this question: the ingestion design does not use a suitable Kafka-to-Snowflake streaming integration.
“Inspect the event integration and notification queue, then repair the approved auto-ingest linkage” responds to this separate finding: the storage event-to-pipe notification path is missing or misconfigured. This question instead needs “Configure the supported Snowflake Connector for Kafka and its streaming ingestion path”, so the alternative does not meet the stated condition.
The scheduled batch cadence does not match file-arrival freshness requirements. “Create an appropriate Snowpipe with automatic cloud event notification for new staged files” applies to that separate problem. The observed case is a team subscribes to a Kafka topic but deploys a generic script that repeatedly downloads a file snapshot instead of consuming record events; choosing this alternative would address the wrong failure mode.