Answer-first summary for fast verification
Answer: Into single files with 100-250 MB of compressed data per file
The correct answer is A because Snowflake documentation and best practices recommend organizing data files into single files with 100-250 MB of compressed data per file for optimal loading performance. This size range provides the best balance between parallel processing efficiency and file management overhead. Option B (1-100 MB) would result in too many small files, causing excessive metadata overhead. Options C and D (1 GB and 4 GB maximum sizes) are too large and would limit parallel processing capabilities, reducing loading performance. The community discussion shows 100% consensus on answer A with multiple users confirming this is correct based on Snowflake's loading optimization guidelines.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the proper data organization structure for loading data into Snowflake?
A
Into single files with 100-250 MB of compressed data per file
B
Into single files with 1-100 MB of compressed data per file
C
Into files of maximum size of 1 GB of compressed data per file
D
Into files of maximum size of 4 GB of compressed data per file
No comments yet.