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

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
A . Load files that are approximately 25 MB or smaller.
B . Remove all dates and timestamps.
C . Load files that are approximately 100-250 MB (or larger)
D . Avoid using embedded characters such as commas for numeric data types
E . Remove semi-structured data types

View Answer

Answer: C, D

Explanation:

When loading data into Snowflake, it is recommended to:

C. Load files that are approximately 100-250 MB (or larger): This size is optimal for parallel processing and can help to maximize throughput. Smaller files can lead to overhead that outweighs the actual data processing time.

D. Avoid using embedded characters such as commas for numeric data types: Embedded characters can cause issues during data loading as they may be interpreted incorrectly. It’s best to clean the data of such characters to ensure accurate and efficient data loading.

These best practices are designed to optimize the data loading process, ensuring that data is loaded quickly and accurately into Snowflake.

Reference: Snowflake Documentation on Data Loading Considerations

[COF-C02] SnowPro Core Certification Exam Study Guide