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">

The correct answer is B. GET_PRESIGNED_URL. GET_PRESIGNED_URL generates a temporary, time-limited pre-signed URL that grants direct HTTPS access to a file stored in a Snowflake stage - without requiring Snowflake credentials. This is the only option that allows an external tool with no Snowflake access to retrieve the…

Data Protection and Data Sharing

Question

Options

ABUILD_SCOPED_FILE_URL
BGET_PRESIGNED_URL
CBUILD_STAGE_FILE_URL
DGET_STAGE_LOCATION

How the community answered

(19 responses)

A
5% (1)
B
89% (17)
C
5% (1)

Explanation

GET_PRESIGNED_URL generates a temporary, time-limited pre-signed URL that grants direct HTTPS access to a file stored in a Snowflake stage - without requiring Snowflake credentials. This is the only option that allows an external tool with no Snowflake access to retrieve the file. BUILD_SCOPED_FILE_URL (A) generates a scoped URL that still requires a valid Snowflake session to use. BUILD_STAGE_FILE_URL (C) generates a persistent URL but also requires a Snowflake session. GET_STAGE_LOCATION (D) returns the stage's cloud storage path, not a shareable access URL.

Topics

#Presigned URLs#Unstructured Data#Internal Stages#External Sharing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice