COF-C02 Question #174: Real Exam Question with Answer & Explanation

The correct answer is D: 100-250 MB. For continuous data loads using Snowpipe, the recommended compressed file size range is between 100-250 MB. This size range is suggested to optimize the number of parallel operations for a load and to avoid size limitations, ensuring efficient and cost-effective data loading.

Data Loading and Unloading

Question

What is the recommended compressed file size range for continuous data loads using Snowpipe?

Options

A8-16 MB
B16-24 MB
C10-99 MB
D100-250 MB

Explanation

For continuous data loads using Snowpipe, the recommended compressed file size range is between 100-250 MB. This size range is suggested to optimize the number of parallel operations for a load and to avoid size limitations, ensuring efficient and cost-effective data loading.

Topics

#Snowpipe#Continuous Data Loading#File Size Best Practices#Performance Optimization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions