SnowPro Core Certification — Question 970

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: B

Explanation

The correct answer is B, BUILD_STAGE_FILE_URL, as it specifically generates a non-expiring URL for a file in a stage. Option A is incorrect because BUILD_SCOPED_FILE_URL does not pertain to staged files, while C and D are irrelevant as they deal with different functionalities and do not produce a permanent file URL.