Answer: Use the COPY command.

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.

Author: LeetQuiz Editorial Team