Answer-first summary for fast verification
Answer: Scoped URL
The question asks for a URL that provides temporary access to staged files without requiring stage privileges or manual token generation. According to Snowflake documentation and the community discussion, Scoped URLs (option B) are specifically designed for this purpose. They are encoded URLs that grant temporary access to staged files without needing privileges on the stage itself, and they automatically expire when the query result cache expires (typically 24 hours). While Pre-Signed URLs (option D) also provide temporary access, they require explicit generation using functions like GET_PRESIGNED_URL and involve manual token management, which contradicts the 'without the need to... issue access tokens' requirement in the question. The community discussion shows strong consensus for B (64% support) with multiple references to official documentation confirming that Scoped URLs fit this exact use case.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When enabling access to unstructured data files, which URL protocol provides temporary, direct access to a staged file without requiring privileges on the stage itself or the manual generation of security tokens?
A
File URL
B
Scoped URL
C
Relative URL
D
Pre-Signed URL