SnowPro Core Certification — Question 452

How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Answer options

• A. Use Snowpipe.
• B. Use the INSERT command.
• C. Use an external table.
• D. Use the COPY command.

Correct answer: D

Explanation

The COPY command is specifically designed for bulk loading data from files in cloud storage, making it the most efficient method for this purpose. While Snowpipe can automate loading, it is not the primary method for bulk loading. The INSERT command is used for smaller, single-row data inserts, and external tables are for querying data without loading it into Snowflake.