SnowPro Core Certification — Question 744

Which SQL command will list the files in a named stage?

Answer options

• A. list @~;
• B. get @%mytable;
• C. list @my_stage;
• D. get @my_stage;

Correct answer: C

Explanation

The correct answer is C, as the 'list' command is specifically designed to display the contents of a named stage, such as '@my_stage'. Options A and D use the 'list' and 'get' commands incorrectly, while option B references a table rather than a stage.