Exam DEA-C02 Topic 1 Question 39 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 39
Topic #: 1
You are designing a Snowpipe pipeline to ingest data from an AWS SQS queue. The queue contains notifications about new files arriving in an S3 bucket. However, due to network issues, some notifications are delayed, causing Snowpipe to potentially miss files. Which of the following strategies, when combined, will BEST address the problem of delayed notifications and ensure data completeness?

Suggested Answer: E Vote an answer

Option E provides the most robust solution. Setting 'MAX FILE AGE to 'DEFAULT' ensures that Snowpipe considers all files, regardless of their age. 'SYSTEM$PIPE FORCE RESUME' can help in some cases. The key component is the supplemental process that actively compares the S3 bucket contents with the loaded data, identifying and loading any missing files due to delayed notifications. This approach guarantees data completeness even with delayed or missed SQS notifications. A,B,C,D doesn't guarantee data completeness. A alone can cause huge latency issue. B is not optimal. C addresses the SQS issue but not guaranteed to catch every case. D requires manual load intervention

by Bonnie at Dec 11, 2025, 01:33 AM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10