The correct answer is C. Pre-signed URL .
Corrected wording:
The option listed as "re-signed URL" appears to be a typing error. The correct term is "pre-signed URL." A pre-signed URL provides temporary access to a file in cloud storage. It is commonly used when a user or application needs time-limited access to a staged file without granting broader permissions to the underlying storage location.
Why C is correct:
A pre-signed URL includes authorization information and is valid only for a defined period of time. This makes it appropriate when users need a limited access window.
Example concept:
SELECT GET_PRESIGNED_URL(@my_stage, ' path/file.csv ' , 3600);
This returns a URL that allows access to the staged file for a limited duration, such as 3600 seconds.
Why the other options are incorrect:
A). A scoped URL is encoded and scoped to a query result context. It is useful for controlled access through Snowflake, but the option that directly provides a time-limited access window to cloud storage is a pre-signed URL.
B). A file URL identifies a file location, but it does not itself provide temporary authorized access.
D). Redirect URL is not the Snowflake file access URL type used for this requirement.
Official Snowflake documentation reference:
Snowflake documentation describes GET_PRESIGNED_URL as a function that returns a pre-signed URL to a staged file, allowing temporary access for a specified expiration time.
Reference: Snowflake Documentation - GET_PRESIGNED_URL; Snowflake Documentation - File functions; SnowPro Core Study Guide - Data Loading and Unloading.
==