Answer: A file URL

The question asks for an object that identifies the database, schema, stage, and file path to files and allows access to roles with stage privileges. A file URL in Snowflake serves this exact purpose - it provides the complete path structure (database.schema.stage/file_path) and access is controlled through role privileges on the stage. The community discussion strongly supports this with 100% consensus for option B, multiple comments confirming it's the correct answer, and references to Snowflake documentation. Option A (scoped URL) is not a standard Snowflake term for file access. Option C (pre-signed URL) is typically used for temporary external access, not internal Snowflake role-based access. Option D (directory table) is used for querying staged files but doesn't inherently provide the path identification and access mechanism described.

Author: LeetQuiz Editorial Team