SnowPro Core Certification — Question 225

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

Answer options

• 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.

Correct answer: C, D

Explanation

The correct answers, C and D, reflect best practices for optimizing data loading into Snowflake. Loading files that are 100-250 MB or larger allows for more efficient processing, while avoiding embedded characters in numeric data types helps prevent parsing errors. Options A, B, and E are not recommended as they either suggest loading too small files or removing critical data types.