Answer-first summary for fast verification
Answer: Organize files into logical paths
Option A is correct because organizing files into logical paths (e.g., by date, region, or source) allows for efficient parallel loading using pattern matching in COPY commands. This enables concurrent COPY statements targeting specific subsets of files, maximizing performance. The community discussion, with 100% consensus and upvoted references to Snowflake documentation, supports this as the best practice. Option B is incorrect as external stages do not maintain caching in the same way internal stages do, and caching is not the primary factor for loading efficiency. Option C is useful but secondary to logical path organization; it complements A but does not alone provide the most efficiency. Option D is inefficient, as large files can bottleneck loading and reduce parallelism compared to well-partitioned data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which practice will provide the MOST efficient loading performance for preparing to load data from an external stage?
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
No comments yet.