SnowPro Advanced: Data Engineer — Question 27

A Data Engineer is implementing a near real-time ingestion pipeline to load data into Snowflake using the Snowflake Kafka connector. There will be three Kafka topics created.
Which Snowflake objects are created automatically when the Kafka connector starts? (Choose three.)

Answer options

• A. Tables
• B. Tasks
• C. Pipes
• D. Internal stages
• E. External stages
• F. Materialized views

Correct answer: A, C, D

Explanation

The correct answer includes Tables, Pipes, and Internal stages because these are the objects that the Snowflake Kafka connector creates automatically to facilitate data ingestion. Tasks are not created automatically by the Kafka connector, and external stages and materialized views are not relevant to the initial setup of the ingestion pipeline.