SnowPro Core Certification — Question 155

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Answer options

• A. INSERT
• B. PUT
• C. GET
• D. COPY

Correct answer: D

Explanation

The COPY command is specifically designed to load data from external files into Snowflake tables, making it the correct choice. The INSERT command is used to add rows to a table, while PUT and GET are used for uploading and downloading files from stages, respectively, and do not load data into tables.