Snowflake Exam COF-C02 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

Lashaunda

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

11 days ago

GET_PRESIGNED_URL is definitely the best option for sharing data externally.

upvoted 0 times

...

Verda

15 days ago

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

upvoted 0 times

...

Paola

1 months ago

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

upvoted 0 times

...

Susy

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

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

upvoted 0 times

...

Alease

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

30 days ago

C) BUILD_STAGE_FILE_URL

upvoted 0 times

...

Theodora

1 months ago

B) GET_PRESIGNED_URL

upvoted 0 times

...

Alison

1 months ago

A) BUILD_SCOPED_FILE_URL

upvoted 0 times

...

Yvonne

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

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

upvoted 0 times

...

Ocie

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

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

upvoted 0 times

...

Marsha

2 months ago

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

upvoted 0 times

...

Ryan

3 months ago

I think the answer is B) GET_PRESIGNED_URL

upvoted 0 times

...

Talia

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