Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner.

Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?
A . Utilize a higher Buffer.flush.time in the connector configuration.
B . Utilize a higher Buffer.size.bytes in the connector configuration.
C . Utilize a lower Buffer.size.bytes in the connector configuration.
D . Utilize a lower Buffer.count.records in the connector configuration.

View Answer

Answer: A

Explanation:

The minimum value supported for the buffer.flush.time property is 1 (in seconds). For higher average data flow rates, we suggest that you decrease the default value for improved latency. If cost is a greater concern than latency, you could increase the buffer flush time. Be careful to flush the Kafka memory buffer before it becomes full to avoid out of memory exceptions. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-streaming-kafka