Snowflake COF-C02 Exam - Topic 1 Question 48 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 48
Topic #: 1

Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake">

ABUILD_SCOPED_FILE_URL

BGET_PRESIGNED_URL

CBUILD_STAGE_FILE_URL

DGET_STAGE_LOCATION

Show Suggested Answer

Suggested Answer: B

The GET_PRESIGNED_URL function in Snowflake generates a pre-signed URL for a file in an internal stage. This URL can be shared with external tools or users who do not have direct access to Snowflake, allowing them to download the file.

Generate Pre-Signed URL:

SELECT GET_PRESIGNED_URL(@my_stage/file.txt);

Share the URL: The generated URL can be shared with external users or applications, enabling them to access the file directly.

Snowflake Documentation: GET_PRESIGNED_URL

Snowflake Documentation: Working with Stages

by Jaleesa at Dec 10, 2024, 01:27 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Hollis

3 months ago

C seems plausible too, but I lean towards B.

upvoted 0 times

...

Hayley

3 months ago

Wait, can you really share data like that? Sounds risky!

upvoted 0 times

...

Rutha

3 months ago

I thought it was A at first, but B makes more sense.

upvoted 0 times

...

Odette

4 months ago

Agreed, B is the way to go!

upvoted 0 times

...

Carli

4 months ago

I think it's definitely B, GET_PRESIGNED_URL.

upvoted 0 times

...

Gerald

4 months ago

I’m leaning towards GET_PRESIGNED_URL too, but I remember there were nuances in the definitions. It’s tricky!

upvoted 0 times

...

Jose

4 months ago

I feel like BUILD_STAGE_FILE_URL could be the answer, but it sounds a bit off. I need to double-check my notes.

upvoted 0 times

...

Marti

4 months ago

I remember something about sharing files, but I can't recall the exact function. Was it BUILD_SCOPED_FILE_URL?

upvoted 0 times

...

Brock

5 months ago

I think it might be GET_PRESIGNED_URL, but I'm not entirely sure. We practiced a similar question in class.

upvoted 0 times

...

Gracia

5 months ago

Ah, I remember learning about this in class. I believe the answer is B, GET_PRESIGNED_URL. That function creates a temporary, shareable URL for the file.

upvoted 0 times

...

Belen

5 months ago

I'm a bit confused on the difference between the "BUILD_" and "GET_" functions. Gotta make sure I understand that before I can answer this.

upvoted 0 times

...

Colette

5 months ago

Okay, let's see. I think the key here is finding a function that can generate a shareable URL for the data, rather than just the file location. Time to review my Snowflake notes!

upvoted 0 times

...

Dulce

5 months ago

Hmm, this one seems tricky. I'll need to think through the different file functions and how they relate to sharing data with external tools.

upvoted 0 times

...

Lashaunda

1 year ago

I'm going with B) GET_PRESIGNED_URL. It's the perfect solution to share data without giving away the whole farm.

upvoted 0 times

Josphine

1 year ago

GET_PRESIGNED_URL is definitely the best option for sharing data externally.

upvoted 0 times

...

Verda

1 year ago

I prefer A) BUILD_SCOPED_FILE_URL. It works well for my needs.

upvoted 0 times

...

Paola

1 year ago

I think B) GET_PRESIGNED_URL is the way to go too. It's secure and efficient.

upvoted 0 times

...

Susy

1 year ago

I think D) GET_STAGE_LOCATION might be the answer, as it specifies the stage location for sharing data

upvoted 0 times

...

Jacquelyne

1 year ago

B) GET_PRESIGNED_URL is the way to go. Gotta love those Snowflake functions that make life easier.

upvoted 0 times

...

Alease

1 year ago

Haha, I bet the answer is not D) GET_STAGE_LOCATION. That would just give you the location of the stage, not a way to share the data!

upvoted 0 times

Janella

1 year ago

C) BUILD_STAGE_FILE_URL

upvoted 0 times

...

Theodora

1 year ago

B) GET_PRESIGNED_URL

upvoted 0 times

...

Alison

1 year ago

A) BUILD_SCOPED_FILE_URL

upvoted 0 times

...

Yvonne

1 year ago

I'm not sure, but C) BUILD_STAGE_FILE_URL could also work for sharing data from internal stage

upvoted 0 times

...

Millie

1 year ago

I agree with Ryan, GET_PRESIGNED_URL makes sense for sharing data externally

upvoted 0 times

...

Ocie

1 year ago

Definitely B) GET_PRESIGNED_URL. That's the way to go to securely share data from Snowflake with external reporting tools.

upvoted 0 times

Aja

1 year ago

GET_PRESIGNED_URL is the way to go for sharing data securely outside of Snowflake.

upvoted 0 times

...

Marsha

1 year ago

I agree, GET_PRESIGNED_URL is the best option for securely sharing data with external tools.

upvoted 0 times

...

Ryan

1 year ago

I think the answer is B) GET_PRESIGNED_URL

upvoted 0 times

...

Talia

1 year ago

I think the answer is B) GET_PRESIGNED_URL. It allows you to generate a temporary, pre-signed URL that can be shared with external tools to access the data.

upvoted 0 times