SnowPro Core Certification — Question 505

Which function returns the URL of a stage using the stage name as the input?

Answer options

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

Correct answer: D

Explanation

The correct answer, GET_STAGE_LOCATION, is specifically designed to return the URL for a stage based on its name. The other options do not serve this particular purpose; for instance, BUILD_STAGE_FILE_URL and BUILD_SCOPED_FILE_URL relate to file URLs, while GET_PRESIGNED_URL is used for generating pre-signed URLs rather than retrieving stage URLs.