ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to Exam

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 Hide Answer
Suggested Answer: A 🗳️
by Alachramkowa at April 28, 2023, 8:22 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
victorleonis
Highly Voted 11 months 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 4 months, 3 weeks ago
Selected Answer: A
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-streaming-kafka
upvoted 2 times
...
hillcat111
9 months, 3 weeks ago
Answer is A and is validated
upvoted 2 times
...
Alachramkowa
12 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago