While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

The correct answer is C. BUILD_STAGE_FILE_URL. BUILD_STAGE_FILE_URL generates a permanent, Snowflake-hosted URL to a staged file using the stage name and relative file path as inputs. This URL is accessible only by authenticated Snowflake users. GET_PRESIGNED_URL generates a temporary, time-limited URL for external…

Data Loading and Unloading

Question

Options

AGET_PRESIGNED_URL
BGET_ABSOLUTE_PATH
CBUILD_STAGE_FILE_URL
DBUILD SCOPED FILE URL

How the community answered

(33 responses)

B
6% (2)
C
91% (30)
D
3% (1)

Explanation

BUILD_STAGE_FILE_URL generates a permanent, Snowflake-hosted URL to a staged file using the stage name and relative file path as inputs. This URL is accessible only by authenticated Snowflake users. GET_PRESIGNED_URL generates a temporary, time-limited URL for external (unauthenticated) access. BUILD_SCOPED_FILE_URL generates a scoped URL that embeds authorization and is typically used in user-defined functions. There is no standard GET_ABSOLUTE_PATH function in Snowflake.

Topics

#unstructured data#staged files#file functions#BUILD_STAGE_FILE_URL

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice