Answer: A single COPY_INTO statement

Snowpipe is Snowflake's continuous data ingestion service that automatically loads data from files as they arrive in cloud storage. According to Snowflake documentation and the community consensus (with multiple upvoted comments supporting C), Snowpipe uses the COPY INTO command internally to load data. A User Defined Function (UDF) cannot be executed with Snowpipe as it's for data transformation, not data loading. A stored procedure cannot be executed with Snowpipe as it's for procedural logic. An INSERT_INTO statement cannot be used with Snowpipe as it's designed for manual data insertion, not automated continuous loading. The community discussion shows strong consensus for C with upvoted comments referencing official documentation, while suggestions for B and D have fewer upvotes and contradict the official Snowpipe implementation.

Author: LeetQuiz Editorial Team