Answer: Pre-signed

The correct answer is C (Pre-signed) because pre-signed URLs in Snowflake provide temporary, time-limited access to files in stages without requiring authentication. This aligns with the question's requirement for direct file access without authentication. While option D (Scoped) refers to BUILD_SCOPED_FILE_URL function, it requires authentication and is used for accessing files within the context of a Snowflake session, not for unauthenticated external access. The community discussion shows strong consensus for C with 75% support and multiple users confirming it's correct, while D only has 25% support and one user initially selected it but later changed to C after realizing their mistake.

Author: LeetQuiz Editorial Team