Answer-first summary for fast verification
Answer: File URL
The correct answer is B (File URL) because it provides reliable, long-lived access to unstructured data files without expiration, which is ideal for custom applications that need consistent access. File URLs precisely identify the object location (database, schema, stage, and path), ensuring applications can fetch files without regenerating links. While A (Scoped URL) is also mentioned for custom applications in documentation, it is more restrictive and intended for role-based access control within the same account, which isn't specified in the question. C (Pre-signed URL) is temporary and expires, making it unsuitable for long-term access. D (Relative URL) is not a Snowflake-specific URL type for unstructured data access. The community discussion shows 75% support for B, with comments emphasizing that File URLs do not expire and are recommended for reliable access in custom applications.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A developer is building a custom application that will continuously read unstructured data files stored on a Snowflake stage. The application requires a permanent URL that does not expire and can be used programmatically with an authorization token. Which URL type is the best choice ?
A
Scoped URL
B
File URL
C
Pre-signed URL
D
Relative URL
