Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam
Question 27

Which Snowflake objects does the Snowflake Kafka connector use? (Choose three.)

    Correct Answer: A, C, E

    The Snowflake Kafka connector uses the following objects: a pipe to ingest data files, an internal user stage to temporarily store data files, and an internal named stage to manage these files. Pipes are essential for data ingestion, internal user stages provide a temporary storage area for the data files, and internal named stages are used to reference the stages for operations within Snowflake.

Discussion
Snow_POptions: ADE

pipe and internal stages

stopthisnowOptions: ADE

The connector creates the following objects for each topic: One internal stage to temporarily store data files for each topic. One pipe to ingest the data files for each topic partition. One table for each topic. https://docs.snowflake.com/en/user-guide/kafka-connector-overview

MultiCloudGuruOptions: ADE

The connector creates the following objects for each topic: One internal stage to temporarily store data files for each topic. One pipe to ingest the data files for each topic partition. One table for each topic.

BigDataBBOptions: ABD

https://docs.snowflake.com/en/user-guide/kafka-connector-overview One table for each topic. One internal stage to temporarily store data files for each topic

BigDataBBOptions: ABE

I finally find the solution, a pipe use a "Snowflake-provided virtual warehouse" so a serverless task. For this reason the answer are A, B, E

BigDataBB

Sorry I correct my self A,B,D https://docs.snowflake.com/en/user-guide/kafka-connector-overview One table for each topic. One internal stage to temporarily store data files for each topic So table stage

BigDataBBOptions: AEF

I think that there is an error, kafka connector uses these snowflake objects: - pipe - internal named stage - tables And not internal table stage

BigDataBB

https://docs.snowflake.com/en/user-guide/kafka-connector-manage

randreag

Is this answer correct?