SnowflakeSnowflake
COF-C02 · Question #80
COF-C02 Question #80: Real Exam Question with Answer & Explanation
Sign in or unlock COF-C02 to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
Data Loading and Unloading
Question
Which of the following are best practices for loading data into Snowflake? (Choose three.)
Options
- AAim to produce data files that are between 100 MB and 250 MB in size, compressed.
- BLoad data from files in a cloud storage service in a different region or cloud platform from the
- CEnclose fields that contain delimiter characters in single or double quotes.
- DSplit large files into a greater number of smaller files to distribute the load among the compute
- EWhen planning which warehouse(s) to use for data loading, start with the largest warehouse
- FPartition the staged data into large folders with random paths, allowing Snowflake to determine the
Unlock COF-C02 to see the answer
You've previewed enough free COF-C02 questions. Unlock COF-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Loading Best Practices#File Sizing#Staging Data#Parallel Processing