Snowpro Advanced Architect · Free Practice Question Medium
Question 21
A telecom client needs to implement Snowpipe for handling large volumes of call data records stored in S3. They report failures when loading files with irregular naming conventions. How would you address this?
- A Grant 'MONITOR' privileges to the ingestion role.
- B Apply a 'PATTERN' clause in the pipe definition that matches valid file names.
- C Use the 'VALIDATE_PIPE_LOAD' function to identify naming errors.
- D Increase the file size threshold in the 'COPY' statement.
Reveal correct answer
Correct answer: B
Explanation
A 'PATTERN' clause ensures only correctly named files are ingested.A. Privileges do not impact file name handling.
B. A proper 'PATTERN' ensures only correctly named files are ingested.
C. Validation identifies errors but does not resolve them.
D. File size thresholds do not affect naming conventions.
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.
