Answer-first summary for fast verification
Answer: A compressed file size greater than 100 MB, and up to 250 MB
The correct answer is A based on Snowflake's official best practices for data ingestion. According to Snowflake documentation and the community discussion, files in the 100-250 MB range offer the best cost-to-performance ratio for Snowpipe. This size range minimizes the per-file overhead charge relative to the total data loaded, making the overhead cost immaterial. Option B (100-250 GB) is too large and not practical for typical Snowpipe operations. Option C (10-100 MB) is the minimum recommended size but not optimal. Option D (1-2 GB) is larger than the recommended range and may not provide the same cost efficiency.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the recommended file size for data loading with Snowpipe?
A
A compressed file size greater than 100 MB, and up to 250 MB
B
A compressed file size greater than 100 GB, and up to 250 GB
C
A compressed file size greater than 10 MB, and up to 100 MB
D
A compressed file size greater than 1 GB, and up to 2 GB