# SnowPro-Advanced-Data-Engineer — Question 605

**Type:** multiple_choice
**Topics:** topic_1

## Question

What is the purpose of the BUILD_STAGE_FILE_URL function in Snowflake?

## Correct Answer

_See scenario._

## Explanation

Selected Answer: C
Generates a Snowflake file URL to a staged file using the stage name and relative file path as inputs. A file URL permits prolonged access to a specified file. That is, the file URL does not expire.
https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/snowflake/SnowPro-Advanced-Data-Engineer/605  
Practice (tracked): https://hiexam.net/study/SnowPro-Advanced-Data-Engineer/practice