Answer: 100-250 MB

The correct answer is D (100-250 MB) based on Snowflake's official documentation and the strong community consensus. Snowflake recommends compressed file sizes of 100-250 MB for optimal Snowpipe performance during continuous data loading. This size range balances efficient loading with minimal latency. The community discussion shows overwhelming support for option D with 90% of respondents selecting it and multiple comments confirming this recommendation. Option C (10-99 MB) is too small and would result in inefficient loading with excessive overhead. Options A (8-16 MB) and B (16-24 MB) are far too small for optimal Snowpipe performance and would significantly impact loading efficiency.

Author: LeetQuiz Editorial Team