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

Lawanda

17 days ago

Just USAGE? Seems too simple!

upvoted 0 times

...

Nobuko

22 days ago

Wait, really? I thought you needed more permissions.

upvoted 0 times

...

Filiberto

28 days ago

Totally agree, that's the minimum requirement!

upvoted 0 times

...

Kris

1 month ago

You need the USAGE privilege on the external stage.

upvoted 0 times

...

Carissa

1 month ago

The answer is clearly READ. How else would you read the file?

upvoted 0 times

...

Laquita

1 month ago

I heard you need a secret handshake and a tin foil hat to access those files.

upvoted 0 times

...

Anglea

2 months ago

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

upvoted 0 times

...

Lillian

2 months ago

Hmm, I'm not sure, maybe EXECUTE?

upvoted 0 times

...

Tomas

2 months ago

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

upvoted 0 times

...

Leila

2 months ago

I think the minimum permission needed is READ.

upvoted 0 times

...

Aliza

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

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

3 months ago

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

upvoted 0 times

...

Rosendo

3 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

4 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

4 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

4 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

4 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

4 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

...