SnowPro Core Certification — Question 636

Which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

Answer options

• A. BUILD_STAGE_FILE_URL
• B. GET_ABSOLUTE_PATH
• C. GET_RELATIVE_PATH
• D. GET_STAGE_LOCATION

Correct answer: A

Explanation

The correct answer is A. BUILD_STAGE_FILE_URL, as it specifically generates a URL for a staged file in Snowflake. The other options do not serve this purpose; B. GET_ABSOLUTE_PATH retrieves the absolute path, C. GET_RELATIVE_PATH provides the relative path, and D. GET_STAGE_LOCATION gives the location of the stage, none of which create a file URL.