ARA-C01 · Question #42
The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps: Step 1: Data files are loaded in a stage. Step 2: An Amazon S3 event
The correct answer is D. The pipe will no longer be able to receive the messages. To restore the system immediately, the. The Snowpipe auto-ingest pipeline via SNS relies on an SQS queue subscription to receive S3 event notifications. If an AWS Administrator deletes the SQS subscription from the SNS topic, the pipe immediately loses its ability to receive new file-ready notifications from S3-no new
Question
The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps:
Step 1: Data files are loaded in a stage. Step 2: An Amazon S3 event notification, published by SNS, informs Snowpipe -- by way of Amazon Simple Queue Service (SQS) - that files are ready to load. Snowpipe copies the files into a queue. Step 3: A Snowflake-provided virtual warehouse loads data from the queued files into the target table based on parameters defined in the specified pipe. If an AWS Administrator accidentally deletes the SQS subscription to the SNS topic in Step 2, what will happen to the pipe that references the topic to receive event messages from Amazon S3?
Exhibit
Options
- AThe pipe will continue to receive the messages as Snowflake will automatically restore the
- BThe pipe will no longer be able to receive the messages and the user must wait for 24 hours from
- CThe pipe will continue to receive the messages as Snowflake will automatically restore the
- DThe pipe will no longer be able to receive the messages. To restore the system immediately, the
How the community answered
(18 responses)- B11% (2)
- C6% (1)
- D83% (15)
Explanation
The Snowpipe auto-ingest pipeline via SNS relies on an SQS queue subscription to receive S3 event notifications. If an AWS Administrator deletes the SQS subscription from the SNS topic, the pipe immediately loses its ability to receive new file-ready notifications from S3-no new data will be ingested. Snowflake does not automatically restore the SQS subscription because the SQS resource and its SNS subscription are managed on the AWS side by the customer. To restore the pipeline immediately, the user must recreate the SQS subscription to the SNS topic (and update the pipe configuration if necessary). Options A and C are incorrect because Snowflake cannot auto-restore customer-managed AWS resources. Option B is incorrect because there is no required 24-hour wait period.
Topics
Community Discussion
No community discussion yet for this question.