
Explanation:
The question asks for Snowflake's recommended method for bulk loading data batches from files already available in cloud storage. Based on Snowflake documentation and the community discussion consensus, the COPY command is the primary recommended approach for bulk loading from cloud storage. While external tables (option C) can access data in cloud storage, they are designed for querying external data without loading it into Snowflake tables, not for bulk loading into Snowflake tables. Snowpipe (option A) is for continuous loading, not batch loading. The INSERT command (option B) is for small-scale manual inserts, not bulk loading. The community discussion shows strong support for D (75% of answers), with one comment suggesting C and D combined, but the question specifically asks for the recommended method for bulk loading, which is clearly the COPY command according to Snowflake's documentation.
What is the Snowflake-recommended method for bulk loading data in batches from files that are already staged in cloud storage?
A
Use Snowpipe.
B
Use the INSERT command.
C
Use an external table.
D
Use the COPY command.
No comments yet.