SnowPro Core Certification — Question 328
A user is preparing to load data from an external stage.
Which practice will provide the MOST efficient loading performance?
Answer options
- A. Organize files into logical paths
- B. Store the files on the external stage to ensure caching is maintained
- C. Use pattern matching for regular expression execution
- D. Load the data in one large file
Correct answer: A
Explanation
Organizing files into logical paths allows for better management and quicker access during the loading process, which enhances performance. The other options, such as storing files on the external stage or loading data as one large file, do not optimize the loading efficiency as effectively as organizing files does.