Answer: GET_PRESIGNED_URL

The question asks which function allows downloading unstructured data files from a Snowflake stage. GET_PRESIGNED_URL (C) is the correct answer because it generates a pre-signed URL that provides temporary, secure access to files without requiring Snowflake authentication, making it ideal for external users or applications. This is supported by the community discussion where multiple comments with upvotes (including one with 3 upvotes) reference official Snowflake documentation confirming GET_PRESIGNED_URL for this purpose. While BUILD_SCOPED_FILE_URL (A) also received votes, it is more suited for internal use within Snowflake (e.g., shares or Snowsight) rather than general external access, and the consensus and documentation favor GET_PRESIGNED_URL for the described use case.

Author: LeetQuiz Editorial Team