Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which of the following are best practices for loading data into Snowflake? (Choose three.)
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.