Snowflake COF-C02 Exam - Topic 1 Question 65 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 65
Topic #: 1

[All COF-C02 Questions]

What is the MINIMUM permission needed to access a file URL from an external stage?

BREAD

CSELECT

DUSAGE

AMODIFY

Show Suggested Answer

Suggested Answer: D

To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not permit the user to alter or drop the stage.

References:

Snowflake Documentation: Access Control

by Buddy at Jan 23, 2026, 03:21 PM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Virgie

6 days ago

I remember practicing a question about external stages, and it might have mentioned needing READ access too.

upvoted 0 times

...

Rosendo

11 days ago

I think the minimum permission needed is something like USAGE on the external stage, but I'm not entirely sure.

upvoted 0 times

...

Cordelia

16 days ago

I feel pretty confident about this. From what I remember, the minimum permission is likely "read" access on the file URL. But I'll double-check the documentation to be sure.

upvoted 0 times

...

Galen

21 days ago

I'm a bit confused on the difference between file URLs and external stages. I'll need to make sure I understand those concepts before I can determine the minimum permission.

upvoted 0 times

...

Joesph

26 days ago

Okay, I've got a strategy. I'll make a list of the common permissions and then evaluate which one is the minimum needed to access a file URL from an external stage.

upvoted 0 times

...

Jade

1 month ago

Hmm, this seems like a tricky one. I'll need to carefully consider the different access levels and how they apply to file URLs versus external stages.

upvoted 0 times

...

Martin

1 month ago

I think I'll start by reviewing the documentation on file URLs and external stages. That should give me a good understanding of the different permission levels required.

upvoted 0 times

...