SnowPro Core Recertification — Question 17

Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?

Answer options

• A. BUILD_SCOPED_FILE_URL
• B. BUILD_STAGE_FILE_URL
• C. GET_ABSOLUTE_PATH
• D. GET_PRESIGNED_URL

Correct answer: A

Explanation

The correct answer is A, BUILD_SCOPED_FILE_URL, which is specifically designed to generate a non-expiring URL for files in Snowflake. The other options either do not create a file URL or are intended for different purposes, such as generating URLs that do expire (D) or obtaining file paths (C).