Which of the following are best practices for loading data into Snowflake? (Choose three.)

Question

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

• A
  88% (57)
• B
  3% (2)
• E
  8% (5)
• F
  2% (1)

Explanation

A is correct: Snowflake recommends staging files between 100 MB and 250 MB (compressed) to optimize load parallelism. C is correct: Enclosing fields containing delimiter characters in quotes prevents parsing errors during ingestion. D is correct: Splitting large files into smaller ones allows the virtual warehouse to distribute load processing across multiple threads/nodes, improving throughput. B is incorrect: Loading from a different region or cloud platform introduces unnecessary egress costs and latency. E is incorrect: Best practice is to start with the smallest warehouse that meets performance needs, scaling up if necessary - not starting with the largest. F is incorrect: Snowflake recommends organizing staged data into logical, granular folder paths (e.g., by date) rather than random paths, to improve pruning and load efficiency.

No community discussion yet for this question.