exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam

Exam SnowPro Advanced Data Engineer topic 1 question 38 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 38
Topic #: 1
[All SnowPro Advanced Data Engineer Questions]

A Data Engineer is working on a continuous data pipeline which receives data from Amazon Kinesis Firehose and loads the data into a staging table which will later be used in the data transformation process. The average file size is 300-500 MB.
The Engineer needs to ensure that Snowpipe is performant while minimizing costs.
How can this be achieved?

  • A. Increase the size of the virtual warehouse used by Snowpipe.
  • B. Split the files before loading them and set the SIZE_LIMIT option to 250 MB.
  • C. Change the file compression size and increase the frequency of the Snowpipe loads.
  • D. Decrease the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis Firehose.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
Snow_P
1 month ago
Selected Answer: D
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare
upvoted 1 times
...
stopthisnow
1 month, 1 week ago
Selected Answer: D
Various tools can aggregate and batch data files. One convenient option is Amazon Kinesis Firehose. Firehose allows defining both the desired file size, called the buffer size, and the wait interval after which a new file is sent (to cloud storage in this case), called the buffer interval. For more information, see the Kinesis Firehose documentation. If your source application typically accumulates enough data within a minute to populate files larger than the recommended maximum for optimal parallel processing, you could decrease the buffer size to trigger delivery of smaller files. Keeping the buffer interval setting at 60 seconds (the minimum value) helps avoid creating too many files or increasing latency.
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago