Exam SnowPro Advanced Architect topic 1 question 22 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 22
Topic #: 1

[All SnowPro Advanced Architect Questions]

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by Alachramkowa at April 28, 2023, 8:22 a.m.

Comments

Submit Cancel

victorleonis

Highly Voted 1 year, 1 month ago

Selected Answer: A

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

upvoted 5 times

...

jjordan

Most Recent 7 months, 2 weeks ago

Selected Answer: A

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-streaming-kafka

upvoted 2 times

...

hillcat111

1 year ago

Answer is A and is validated

upvoted 2 times

...

Alachramkowa

1 year, 2 months ago

With lower buffer.count.records the buffer limits will be reached earlier, the file will be flushed and sent for ingestion through Snowpipe more frequently, thus increasing the cost

upvoted 3 times

...