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

Adrianna

2 days ago

But what about READ access? Isn't that needed too?

upvoted 0 times

...

Malcolm

7 days ago

Yeah, USAGE is essential for external stages.

upvoted 0 times

...

Andra

13 days ago

I think it's USAGE permission.

upvoted 0 times

...

Jade

18 days ago

Yup, just USAGE for file URLs.

upvoted 0 times

...

Lawanda

2 months ago

Just USAGE? Seems too simple!

upvoted 0 times

...

Nobuko

2 months ago

Wait, really? I thought you needed more permissions.

upvoted 0 times

...

Filiberto

2 months ago

Totally agree, that's the minimum requirement!

upvoted 0 times

...

Kris

3 months ago

You need the USAGE privilege on the external stage.

upvoted 0 times

...

Carissa

3 months ago

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

upvoted 0 times

...

Laquita

3 months ago

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

upvoted 0 times

...

Anglea

3 months ago

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

upvoted 0 times

...

Lillian

3 months ago

Hmm, I'm not sure, maybe EXECUTE?

upvoted 0 times

...

Tomas

3 months ago

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

upvoted 0 times

...

Leila

4 months ago

I think the minimum permission needed is READ.

upvoted 0 times

...

Aliza

4 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

4 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

5 months ago

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

upvoted 0 times

...

Rosendo

5 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

5 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

5 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

5 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

6 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

6 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

...