SnowPro Core Certification — Question 319

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

Answer options

• A. Pipe
• B. External stage
• C. Task
• D. Stream

Correct answer: A

Explanation

The correct answer is A, Pipe, which facilitates the automatic loading of data as soon as files arrive in the specified cloud storage. The other options, such as External stage, provide access to the files but do not automatically load them; Task is used for scheduling jobs, and Stream is utilized for tracking changes in data.