Question 7

Explanation

✅ LIST

Explanation:

The LIST command in Snowflake is used to return a list of files stored in a stage, whether it's an internal stage, external stage, user stage, or table stage. It’s especially useful for verifying which files are available before loading them into a table or performing other operations.

Example usage:

LIST @my_stage;

❌ Why the other options are incorrect?

• COPY INTO → Used to load data from a stage into a table or unload data from a table into a stage, not to list files.

• PUT → Uploads files from a local file system to an internal stage.

• GET → Downloads files from an internal stage to a local file system.

You can explore more in Snowflake’s LIST command documentation.