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

Anglea

3 days ago

Isn't it just NONE? I mean, it's a URL, right?

upvoted 0 times

...

Lillian

8 days ago

Hmm, I'm not sure, maybe EXECUTE?

upvoted 0 times

...

Tomas

13 days ago

Definitely WRITE, you need to be able to modify the file.

upvoted 0 times

...

Leila

18 days ago

I think the minimum permission needed is READ.

upvoted 0 times

...

Aliza

24 days ago

I think it’s definitely about permissions, but I’m confused if it’s just USAGE or if there’s more to it.

upvoted 0 times

...

Chau

29 days ago

I feel like the answer could be related to the role assigned to the user, but I can't recall the specifics.

upvoted 0 times

...

Virgie

2 months ago

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

upvoted 0 times

...

Rosendo

2 months 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

2 months 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

2 months 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

2 months 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

3 months 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

3 months 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

...