An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake

Question

Options

• AIncrease the size of the virtual warehouse.
• BCreate a multi-cluster warehouse and merge smaller files to create bigger files.
• CCreate a specific storage landing bucket to avoid file scanning.
• DChange the file format from CSV to JSON.

• A
  4% (1)
• B
  83% (19)
• C
  9% (2)
• D
  4% (1)

Explanation

According to the Snowflake documentation, the data loading performance can be improved by following some best practices and guidelines for preparing and staging the data files. One of the recommendations is to aim for data files that are roughly 100-250 MB (or larger) in size compressed, as this will optimize the number of parallel operations for a load. Smaller files should be aggregated and larger files should be split to achieve this size range. Another recommendation is to use a multi- cluster warehouse for loading, as this will allow for scaling up or out the compute resources depending on the load demand. A single-cluster warehouse may not be able to handle the load concurrency and throughput efficiently. Therefore, by creating a multi-cluster warehouse and merging smaller files to create bigger files, the data loading performance can be improved.

No community discussion yet for this question.