
Answer-first summary for fast verification
Answer: 5 GB
The correct answer is B (5 GB) based on Snowflake documentation and community consensus. The MAX_FILE_SIZE parameter in COPY INTO location statements controls the maximum size of output files when unloading data to external stages. While the default value is 16 MB, the maximum supported file size for external stages (Amazon S3, Google Cloud Storage, or Microsoft Azure) is 5 GB. This is clearly stated in the Snowflake documentation referenced in the community discussion, and option B has overwhelming community support (90%) with multiple upvoted comments confirming this limit. Option D (16 GB) is incorrect as it exceeds the actual maximum, and options A (1 GB) and C (10 GB) are also incorrect as they don't match the documented 5 GB maximum.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.