Answer-first summary for fast verification
Answer: GET_PRESIGNED_URL
The question requires generating a URL for unstructured data from an internal stage that can be accessed by an external reporting tool without Snowflake authentication. GET_PRESIGNED_URL (C) is the correct choice because it creates pre-signed URLs that are open and accessible without requiring Snowflake credentials, making them ideal for external tools. The community discussion strongly supports this with 75% selecting C and the highest upvoted comment (8 upvotes) explicitly citing Snowflake documentation that pre-signed URLs are 'open; any user or application can directly access or download the files' and 'ideal for business intelligence applications or reporting tools.' BUILD_STAGE_FILE_URL (B) requires Snowflake authentication, making it unsuitable for external tools without access. BUILD_SCOPED_FILE_URL (A) and GET_STAGE_LOCATION (D) are not appropriate as they either require authentication or don't generate accessible URLs for external consumption.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user needs to share unstructured data from an internal stage with an external reporting tool that cannot connect to Snowflake. Which Snowflake function should be used to generate a URL for the data file?
A
BUILD_SCOPED_FILE_URL
B
BUILD_STAGE_FILE_URL
C
GET_PRESIGNED_URL
D
GET_STAGE_LOCATION
No comments yet.