COF-R02 practice question 35 of 35

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. Correct answer

C: Enclose fields that contain delimiter characters in single or double quotes. Correct answer

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. Correct answer

F: Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Correct Answer:

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.; E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Explanation

Keep practicing

Take the free COF-R02 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test