Free Snowflake SnowPro-Core Actual Exam Questions - Question 2 Discussion
staged file using the stage name and relative file path as inputs?
Actually, I'd rule out A because GET_PRESIGNED_URL usually creates a time-limited access link, not just the file URL itself. That leaves C and B as closer options. B’s name suggests it gives an absolute path, but that might just be a file path, not a full hosted URL. C, BUILD_STAGE_FILE_URL, sounds like it specifically builds the hosted file URL from the stage and file path, which matches what the question asks. So I’d say it’s more likely C since it fits the idea of generating the URL directly.
Maybe B? GET_ABSOLUTE_PATH sounds like it would give you the full path from stage and file, which could be the Snowflake-hosted URL they’re asking for.
C imo, it sounds like the function meant to build the URL without focusing on access rights.
C imo, BUILD_STAGE_FILE_URL sounds like it’s designed to create the URL based on stage and path inputs without adding access tokens, unlike GET_PRESIGNED_URL which is more about secure access.
It’s A since it specifically returns a URL with proper access permissions.
A imo, GET_PRESIGNED_URL makes more sense for generating URLs to staged files, especially with permissions handled. BUILD_STAGE_FILE_URL sounds like it might just construct a path, not a full URL.
Pretty sure it’s C. BUILD_STAGE_FILE_URL since it mentions stage name and file path directly.