Answer: GET_STAGE_LOCATION

The question asks which function returns the URL of a stage using the stage name as input. GET_STAGE_LOCATION is the correct function for this purpose, as it retrieves the URL for an external or internal named stage using the stage name as input. This is supported by the community discussion, where option D has 71% of the votes and multiple comments with high upvotes confirm that GET_STAGE_LOCATION is the right choice, referencing Snowflake documentation. BUILD_STAGE_FILE_URL (A) returns a URL for a specific file within a stage, not the stage itself. BUILD_SCOPED_FILE_URL (B) is not a standard Snowflake function. GET_PRESIGNED_URL (C) generates a temporary URL for a specific stage object (file), not the stage URL, which is also clarified in the discussion.

Author: LeetQuiz Editorial Team