
Explanation:
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.
Ultimate access to all questions.
No comments yet.
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