ARA-C01 practice question 2 of 25

What is a characteristic of event notifications in Snowpipe?

Full set: 162 questions
Answer options
A: The load history is stored In the metadata of the target table.
B: Notifications identify the cloud storage event and the actual data in the files.
C: Snowflake can process all older notifications when a paused pipe Is resumed.
D: When a pipe Is paused, event messages received for the pipe enter a limited retention period. Correct answer
Correct Answer:
D. When a pipe Is paused, event messages received for the pipe enter a limited retention period.
Explanation

Event notifications in Snowpipe are messages sent by cloud storage providers to notify Snowflake of new or modified files in a stage. Snowpipe uses these notifications to trigger data loading from the stage to the target table. When a pipe is paused, event messages received for the pipe enter a limited retention period, which varies depending on the cloud storage provider. If the pipe is not resumed within the retention period, the event messages will be discarded and the data will not be loaded automatically. To load the data, the pipe must be resumed and the COPY command must be executed manually. This is a characteristic of event notifications in Snowpipe that distinguishes them from other options. Reference: Snowflake Documentation: Using Snowpipe, Snowflake Documentation: Pausing and Resuming a Pipe

Scroll to Top