Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

The correct answer is C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters such as commas for numeric data types. https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

Data Loading and Unloading

Question

Options

ALoad files that are approximately 25 MB or smaller.
BRemove all dates and timestamps.
CLoad files that are approximately 100-250 MB (or larger)
DAvoid using embedded characters such as commas for numeric data types
ERemove semi-structured data types

How the community answered

(30 responses)

A
10% (3)
B
17% (5)
C
70% (21)
E
3% (1)

Explanation

https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

Topics

#data loading best practices#file sizing#CSV loading

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice