Snowpro Advanced Architect · Free Practice Question Medium
Question 16
How can you configure Snowflake to avoid loading unnecessary directory blobs from a GCS stage?
- A Use the PATTERN clause in the COPY INTO command
- B Manually delete directory blobs from the GCS bucket
- C Enable ON_ERROR='SKIP_FILE' to bypass directory blobs
- D Use an external table to filter directory blobs before loading
Reveal correct answer
Correct answer: A
Explanation
PATTERN ensures that only valid files are included during data loading.A. PATTERN excludes directory blobs based on file name patterns.
B. Manual deletion is time-consuming and prone to errors.
C. SKIP_FILE handles errors but doesn't prevent directory blob inclusion.
D. External tables don't support direct filtering of directory blobs.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
