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

9 months ago

C seems plausible too, but I lean towards B.

upvoted 0 times

...

Hayley

9 months ago

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

upvoted 0 times

...

Rutha

9 months ago

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

upvoted 0 times

...

Odette

10 months ago

Agreed, B is the way to go!

upvoted 0 times

...

Carli

10 months ago

I think it's definitely B, GET_PRESIGNED_URL.

upvoted 0 times

...

Gerald

10 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

10 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

10 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

11 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

11 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

11 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

11 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

11 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

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

2 years ago

GET_PRESIGNED_URL is definitely the best option for sharing data externally.

upvoted 0 times

...

Verda

2 years ago

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

upvoted 0 times

...

Paola

2 years ago

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

upvoted 0 times

...

Susy

2 years ago

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

upvoted 0 times

...

Jacquelyne

2 years ago

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

upvoted 0 times

...

Alease

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

2 years ago

C) BUILD_STAGE_FILE_URL

upvoted 0 times

...

Theodora

2 years ago

B) GET_PRESIGNED_URL

upvoted 0 times

...

Alison

2 years ago

A) BUILD_SCOPED_FILE_URL

upvoted 0 times

...

Yvonne

2 years ago

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

upvoted 0 times

...

Millie

2 years ago

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

upvoted 0 times

...

Ocie

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

2 years ago

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

upvoted 0 times

...

Marsha

2 years ago

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

upvoted 0 times

...

Ryan

2 years ago

I think the answer is B) GET_PRESIGNED_URL

upvoted 0 times

...

Talia

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