Answer: Pre-signed URL

The question asks for a URL type that allows access to files in a stage without Snowflake authentication. A pre-signed URL (option D) is specifically designed for this purpose, as it provides temporary, authenticated access to staged files without requiring the user to have Snowflake credentials or roles. This is confirmed by the community discussion, where option D has 100% consensus and upvoted comments reference Snowflake documentation for GET_PRESIGNED_URL. Option A (File URL) requires a role with sufficient privileges, option B (Staged URL) is not a valid Snowflake term, and option C (Scoped URL) still requires user authentication, making them unsuitable for unauthenticated access.

Author: LeetQuiz Editorial Team