SnowPro Advanced: Architect — Question 28

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?

Answer options

• 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.

Correct answer: A

Explanation

Choosing a higher Buffer.flush.time allows the connector to accumulate more data before sending it to Snowflake, which can reduce the frequency of writes and thereby lower costs. In contrast, increasing Buffer.size.bytes or decreasing Buffer.size.bytes will not necessarily optimize the cost and may lead to more frequent data transfers. Similarly, lowering Buffer.count.records could increase the number of writes, leading to higher costs.