Answer: BUILD_STAGE_FILE_URL

The question asks for a function that generates a permanent (non-expiring) Snowflake-hosted URL to a staged file using the stage name and relative file path. BUILD_STAGE_FILE_URL (option B) is the correct choice because it specifically creates a permanent URL that does not expire, as confirmed by the community discussion where all responses (100%) select B and provide examples like SELECT BUILD_STAGE_FILE_URL('mystage', 'path/to/file.csv') AS file_url. BUILD_SCOPED_FILE_URL (A) generates temporary URLs that expire, GET_ABSOLUTE_PATH (C) returns a path but not a URL, and GET_PRESIGNED_URL (D) creates time-limited URLs, making them unsuitable for permanent access.

Author: LeetQuiz Editorial Team