SnowPro Core Certification — Question 704
What is generally the FASTEST way to bulk load data files from a stage?
Answer options
- A. Specifying a list of specific files to load
- B. Loading by path (internal stages) / prefix
- C. Using the Snowpipe REST API
- D. Using pattern matching to identify specific files by pattern
Correct answer: A
Explanation
The fastest way to bulk load data files is by specifying a list of specific files to load, as it allows for direct targeting of desired files without additional overhead. Other options like loading by path or using pattern matching introduce more complexity and processing time, while the Snowpipe REST API is generally more suited for continuous loading rather than bulk operations.