Answer: GET

The correct answer is B (GET) because the GET command is specifically designed to download files from Snowflake stages (both internal and external) to a local file system. While there is some community confusion about external stage support, the official Snowflake documentation and the highest-voted community comments (63% support for B with 5 upvotes) confirm that GET works with both internal and external stages. The COPY INTO command (A) is used to unload data from tables to stages, not from stages to local systems. PUT (C) is for uploading files from local systems to stages, and TRANSFER (D) is not a valid Snowflake command for this purpose.

Author: LeetQuiz Editorial Team