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

Ocie

9 days 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

...

Ryan

17 days ago

I think the answer is B) GET_PRESIGNED_URL

upvoted 0 times

...

Talia

21 days 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

Evan

11 days ago

I think it might be C) BUILD_STAGE_FILE_URL.

upvoted 0 times

...

Miesha

14 days ago

I believe the answer is B) GET_PRESIGNED_URL.

upvoted 0 times

...