Snowflake SOL-C01 Exam - Topic 1 Question 11 Discussion

Actual exam question for Snowflake's SOL-C01 exam

Question #: 11
Topic #: 1

[All SOL-C01 Questions]

What SQL command will return a list of all files in a stage?

APUT

BLIST

CGET

DCOPY INTO

Show Suggested Answer

Suggested Answer: B

LIST @stage_name displays all files present in a stage (internal or external).

PUT uploads local files to an internal stage.

GET downloads files from an internal stage.

COPY INTO loads or unloads data but does not list files.

==================

by Gabriele at May 16, 2026, 07:16 PM

Limited Time Offer

25%

Off

Get Premium SOL-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Adela

13 hours ago

Totally agree, LIST is the way to go!

upvoted 0 times

...

Dulce

6 days ago

The correct command is B) LIST.

upvoted 0 times

...

Boris

11 days ago

I’m pretty confident that LIST is the correct answer, but I should double-check my notes just in case.

upvoted 0 times

...

Darci

16 days ago

I’m confused between LIST and GET. I feel like GET is for downloading files, but I can't recall clearly.

upvoted 0 times

...

Mayra

21 days ago

I remember practicing a question about file management in SQL, and LIST seemed to be the right choice there too.

upvoted 0 times

...

Hassie

26 days ago

I think the command to list files in a stage is LIST, but I’m not entirely sure.

upvoted 0 times

...

Devora

1 month ago

I feel like COPY INTO is related to data loading, so it can't be the right answer here.

upvoted 0 times

...

Aron

1 month ago

I’m a bit confused; I thought PUT was for uploading files, not listing them.

upvoted 0 times

...

Venita

1 month ago

I remember practicing a similar question, and I think LIST was the answer.

upvoted 0 times

...

Lenita

3 months ago

I think the command to list files in a stage is LIST, but I’m not completely sure.

upvoted 0 times

...