COF-C02 Question 402

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C1

  Split larger files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse. The number of data files that are processed in parallel is determined by the amount of compute resources in a warehouse. We recommend splitting large files by line to avoid records that span chunks. https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare#:~:text=Split%20larger%20files,that%20span%20chunks.

• Chose C1

  correct

• Chose C3

  I'd go for C. A severless approach (A) is usually not recommended for large files due to the higher costs.