SnowPro Core Certification — Question 207

What is the recommended file sizing for data loading using Snowpipe?

Answer options

• A. A compressed file size greater than 100 MB, and up to 250 MB
• B. A compressed file size greater than 100 GB, and up to 250 GB
• C. A compressed file size greater than 10 MB, and up to 100 MB
• D. A compressed file size greater than 1 GB, and up to 2 GB

Correct answer: A

Explanation

The recommended file sizing for Snowpipe is to use compressed files that are greater than 100 MB and up to 250 MB, as this size range optimizes performance and resource management during data loading. The other options either exceed the recommended size or are too small, which may lead to inefficiencies in the data loading process.