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.
A, C, D
https://docs.snowflake.com/en/user-guide/data-load-considerations.html
A. To optimize the number of parallel operations for a load, we recommend aiming to produce data files roughly 100-250 MB (or larger) in size compressed.
C. Fields that contain delimiter characters should be enclosed in quotes (single or double). If the data contains single or double quotes, then those quotes must be escaped.
D. Split larger files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
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.
b: more latency and cost, e:more cost f: less efficient
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Tapasgup007
Highly Voted 1 year, 11 months agoManish5031994
1 year, 2 months agoManocs
Highly Voted 2 years, 2 months agopranalig
Most Recent 5 months agoPrashantGupta1616
5 months, 2 weeks agoAnireddySaikiranReddy
8 months, 4 weeks ago_yyukta
8 months, 4 weeks agoSoftwareEngineerGoneData
1 year, 3 months agoRajuNaik
1 year, 6 months agovini15
1 year, 7 months agonishantgshah
1 year, 8 months agoEmiB
1 year, 8 months agoMadhavan71
1 year, 10 months agobaig123
1 year, 11 months agojveag
2 years, 2 months agoWilliam_20
2 years, 2 months ago