When loading data into Snowflake, how should the data be organized?

The correct answer is A. Into single files with 100-250 MB of compressed data per file. When loading data into Snowflake, it is recommended to organize the data into single files with 100- 250 MB of compressed data per file. This size range is optimal for parallel processing and can help in achieving better performance during data loading operations.

Data Loading and Unloading

Question

Options

AInto single files with 100-250 MB of compressed data per file
BInto single files with 1-100 MB of compressed data per file
CInto files of maximum size of 1 GB of compressed data per file
DInto files of maximum size of 4 GB of compressed data per file

How the community answered

(43 responses)

A
86% (37)
B
2% (1)
C
2% (1)
D
9% (4)

Explanation

When loading data into Snowflake, it is recommended to organize the data into single files with 100- 250 MB of compressed data per file. This size range is optimal for parallel processing and can help in achieving better performance during data loading operations.

Topics

#Data Loading#File Size#Best Practices#Staging

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice