SnowPro Core Certification — Question 132

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Answer options

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

Correct answer: A, C, D

Explanation

The correct answers A, C, and D are best practices because they help optimize the data loading process in Snowflake by ensuring efficient file sizes, proper handling of delimiters, and effective distribution of workload. Options B and E suggest strategies that may incur unnecessary costs or lead to inefficiencies, while option F complicates the data loading process without providing a clear benefit.