snowflake · SnowPro-Advanced-Data-Engineer · Q605 · multiple_choice · topic_1

What is the purpose of the BUILD_STAGE_FILE_URL function in Snowflake?

A.It generates an encrypted URL for accessing a file in a stage.
B.It generates a staged URL for accessing a file in a stage.
C.It generates a permanent URL for accessing files in a stage.
D.It generates a temporary URL for accessing a file in a stage.

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

Practice with progress tracking

Start tracked practice Pricing