SnowPro Advanced: Data Engineer — Question 14

What is the purpose of the BUILD_STAGE_FILE_URL function in Snowflake?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because the BUILD_STAGE_FILE_URL function is specifically designed to generate a permanent URL that allows for the access of files stored in a stage. Options A and D are incorrect as they refer to encrypted and temporary URLs, which are not the function's purpose. Option B is also incorrect because it refers to a staged URL, which does not indicate permanence.