SnowPro Advanced: Architect — Question 183

An Architect wants to stream website logs near real-time to Snowflake and has decided to use Snowflake Connector for Kafka.

What characteristics should the Architect consider regarding the different ingestion methods? (Choose two.)

Answer options

• A. Snowpipe Streaming is the default ingestion method.
• B. Snowpipe Streaming supports schema detection.
• C. Snowpipe has a lower latency than Snowpipe Streaming.
• D. Snowpipe Streaming automatically flushes data every one second.
• E. Snowpipe can handle jumps or resetting offsets by default.

Correct answer: A, E

Explanation

The correct answers are A and E. Snowpipe Streaming is indeed the default ingestion method for real-time data streaming, while Snowpipe can manage jumps or reset offsets effectively. Options B and C are incorrect because Snowpipe Streaming does support schema detection, and Snowpipe does not have lower latency compared to Snowpipe Streaming. Option D is also false, as the automatic flush timing is specific to the implementation of the streaming process.