Snowpro Advanced Architect · Free Practice Question Medium
Question 37
You are setting up Snowpipe for a retail chain that loads inventory data from multiple regions. They report mismatched data in the target table. What would you investigate first?
- A Check the stage permissions for each region.
- B Recreate the pipe with separate stages for each region.
- C Verify the 'COPY' statement's 'PATTERN' clause for region-specific data paths.
- D Increase the timeout settings for the Snowpipe API calls.
Reveal correct answer
Correct answer: C
Explanation
Region-specific 'PATTERN' clauses ensure accurate data ingestion.A. Permissions issues do not cause data mismatches directly.
B. Recreating pipes may solve issues but is not the first step.
C. Incorrect 'PATTERN' clauses can cause data mismatches.
D. Timeouts do not lead to mismatched data.
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.
