SnowPro Core Certification — Question 312

Which of the following can be executed/called with Snowpipe?

Answer options

• A. A User Defined Function (UDF)
• B. A stored procedure
• C. A single COPY_INTO statement
• D. A single INSERT_INTO statement

Correct answer: C

Explanation

The correct answer is C, as Snowpipe specifically allows for the execution of a single COPY_INTO statement to load data into Snowflake. Options A and B refer to functions and procedures that cannot be directly invoked by Snowpipe. Option D is incorrect because Snowpipe does not support direct INSERT_INTO statements.