Answer: The length of time specified in the expiration_time argument

The question asks about the validity duration of a pre-signed URL for accessing unstructured data files in an external stage. According to Snowflake documentation, pre-signed URLs have a configurable expiration time specified via the expiration_time argument when generating the URL. This differs from regular file URLs which may be permanent. The community discussion shows conflicting opinions, but the most technically accurate response based on Snowflake's documentation is that pre-signed URLs expire after the time specified in the expiration_time parameter. Option B (unlimited time) applies to regular file URLs, not pre-signed URLs. Option A (remainder of session) and Option D (same as query results cache) are incorrect as they don't align with how pre-signed URL expiration works in Snowflake.

Author: LeetQuiz Editorial Team