SnowPro Core Certification — Question 676

Which 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. BUILD_SCOPED_FILE_URL
• C. GET_PRESIGNED_URL
• D. GET_STAGE_LOCATION

Correct answer: A

Explanation

The correct answer is A, BUILD_STAGE_FILE_URL, as it specifically generates a URL for files staged in Snowflake. Options B, C, and D serve different purposes: BUILD_SCOPED_FILE_URL is for scoped files, GET_PRESIGNED_URL generates a presigned URL for accessing files, and GET_STAGE_LOCATION retrieves the location of a stage, none of which directly create a file URL using the stage name and file path.