SnowPro Advanced: Architect — Question 182

An Architect plans to stream data using the Snowflake Connector for Kafka in Snowpipe.

What setting will optimize costs?

Answer options

• A. Set a value of 1 to buffer.flush.time.
• B. Set a value of 1 to buffer.count.records.
• C. Set a value of 10 MB to buffer.size.bytes.
• D. Maximize the number of micro-partitions.

Correct answer: C

Explanation

Setting buffer.size.bytes to 10 MB allows for larger batches of data to be processed at once, which can lead to cost efficiency by reducing the number of transactions. The other options either focus on minimizing records or flush times, which may not optimize costs effectively in this context.