Answer: 100-250 MB

The correct answer is B (100-250 MB) based on Snowflake's official documentation and community consensus. Snowflake recommends compressed file sizes of 100-250 MB for optimal performance when loading data via Snowpipe. This size range provides the best cost-to-performance ratio by balancing parallel operations across warehouse servers while avoiding the overhead of too many small files. The community discussion shows unanimous support for this answer with references to official Snowflake resources, including their blog and community articles that specifically recommend this file size range for efficient data ingestion.

Author: LeetQuiz Editorial Team