DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ65

VerifiedOfficial exam objectives/topics

A Data Engineer is building a near-real-time ingestion pipeline to load data into Snowflake with the Snowflake Kafka connector. Three Kafka topics will be created.

Which Snowflake objects does the Kafka connector create automatically when it starts?

Choose three
Explanation

For each Kafka topic, the Snowflake Kafka connector uses a target table, a named internal stage to temporarily hold data files, and Snowpipe pipes to ingest those files (one pipe per topic partition). It creates the table when the target table does not already exist. The connector does not automatically create tasks, external stages, or materialized views.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!