Answer: File URL

The correct answer is B (File URL) because it permanently encodes the database, schema, stage, and file path for staged files in Snowflake, allowing any role with appropriate stage privileges to access the unstructured data files directly. This aligns with Snowflake's documentation where File URLs provide a structured path to staged content. Option A (Scoped URL) is incorrect as it provides temporary, role-scoped access rather than permanent path encoding. Option C (Pre-signed URL) is incorrect as it generates temporary, time-limited access URLs, typically for external cloud storage. Option D (HTTPS URL) is too generic and does not specifically encode Snowflake's internal database, schema, and stage structure.

Author: LeetQuiz Editorial Team