Snowflake
COF-R02 · Question #176
COF-R02 Question #176: Real Exam Question with Answer & Explanation
The correct answer is B. Load data from files in a cloud storage service in a different region or cloud platform from the C. Enclose fields that contain delimiter characters in single or double quotes. E. When planning which warehouse(s) to use for data loading, start with the largest warehouse. See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.