Exam SnowPro Core topic 1 question 277 discussion

Loading data files roughly 100-250 MB in size or larger reduces the overhead charge relative to the amount of total data loaded to the point where the overhead cost is immaterial.

A is correct Answer

C. When the underlying data has changed

i think A is the answer

correct

A is correct

There is a fixed, per-file overhead charge for Snowpipe in addition to the compute processing costs. We recommend files at least above 10 MB on average, with files in the 100 to 250 MB range offering the best cost-to-performance ratio. https://www.snowflake.com/blog/best-practices-for-data-ingestion/#:~:text=Recommended%20file%20size%20for%20Snowpipe%20and%20cost%20considerations&text=We%20recommend%20files%20at%20least,cost%2Dto%2Dperformance%20ratio.

I suspect these "best practices" where updated with time. I have documentation dated June 2020 from attending a Snowflake Quickstart Training (by Snowflake Proffessional Services) that aligns with the moderated answer.

A https://www.snowflake.com/blog/best-practices-for-data-ingestion/#:~:text=Recommended%20file%20size%20for%20Snowpipe%20and%20cost%20considerations&text=We%20recommend%20files%20at%20least,cost%2Dto%2Dperformance%20ratio.

Loading data files roughly 100-250 MB in size or larger reduces the overhead charge relative to the amount of total data loaded to the point where the overhead cost is immaterial.

Loading data files roughly 100-250 MB in size or larger reduces the overhead charge relative to the amount of total data loaded to the point where the overhead cost is immaterial.

Loading data files roughly 100-250 MB in size or larger reduces the overhead charge relative to the amount of total data loaded to the point where the overhead cost is immaterial.