SnowPro Core Certification — Question 154

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Answer options

• A. 10-50 MB
• B. 100-250 MB
• C. 300-500 MB
• D. 1000-1500 MB

Correct answer: B

Explanation

The recommended compressed file size for loading data into Snowflake via Snowpipe is between 100-250 MB, as it balances loading efficiency and performance. Sizes smaller than 100 MB may lead to higher overhead, while larger files may not be processed optimally by Snowpipe.