SnowPro Core Certification — Question 1033

While working with unstructured data, 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. BUILD_SCOPED_FILE_URL
• D. GET_PRESIGNED_URL

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 using the provided inputs. The other options do not serve this purpose; GET_ABSOLUTE_PATH typically refers to local file paths, BUILD_SCOPED_FILE_URL is used for different scoping, and GET_PRESIGNED_URL is related to temporary access links rather than direct file staging.