SnowPro Core Certification — Question 1035

Which command allows for continuous loading of data files as soon as they are available in a stage?

Answer options

• A. COPY INTO [table]
• B. PUT
• C. CREATE PIPE
• D. GET

Correct answer: C

Explanation

The correct answer is C, CREATE PIPE, which is specifically designed for continuous data loading from a stage as files arrive. The other options do not facilitate this ongoing process; A is for loading data into a table, B is for uploading files to a stage, and D is for retrieving files from a stage.