Explanation:
The correct answers are A, C, and D based on Snowflake's official documentation and strong community consensus. Option A is optimal because Snowflake recommends compressed file sizes of 100-250 MB to balance parallel processing efficiency with file management overhead. Option C is essential for data integrity, as enclosing delimiter-containing fields in quotes prevents parsing errors during loading. Option D improves performance by splitting large files to leverage Snowflake's distributed compute resources effectively. Option B is incorrect due to potential cross-region data transfer costs and latency. Option E is suboptimal as starting with the largest warehouse may incur unnecessary costs without performance benefits. Option F is inefficient compared to structured partitioning strategies.
Ultimate access to all questions.
No comments yet.
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A
Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
B
Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
C
Enclose fields that contain delimiter characters in single or double quotes.
D
Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
E
When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
F
Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.