ARA-C01 practice question 2 of 25
What is a characteristic of event notifications in Snowpipe?
Full set: 162 questionsEvent 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
Keep practicing
Take the free ARA-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ARA-C01 practice questions
- Question 1An Architect needs to improve the performance of reports that pull data from multiple Sno…
- Question 3Based on the Snowflake object hierarchy, what securable objects belong directly to a Snow…
- Question 4An Architect has designed a data pipeline that Is receiving small CSV files from multiple…
- Question 5Which data models can be used when modeling tables in a Snowflake environment? (Select TH…
- Question 6A user has the appropriate privilege to see unmasked data in a column. If the user loads …
- Question 7A company is using Snowflake in Azure in the Netherlands. The company analyst team also h…
