Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
A . Pipe
B . External stage
C . Task
D . Stream

View Answer

Answer: A

Explanation:

In Snowflake, a Pipe is the object designed to enable the continuous, near-real-time loading of data from files as soon as they are available in a cloud storage location. Pipes use

Snowflake’s COPY command to load data and can be associated with a Stage object to monitor for new files. When new data files appear in the stage, the pipe automatically loads the data into the target table.

Reference: Snowflake Documentation on Pipes

SnowPro® Core Certification Study Guide

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html