Answer: Directory table

A Directory Table is the correct answer because it is specifically designed as an implicit object layered on a stage in Snowflake, providing metadata about files stored in both internal and external stages. It automatically tracks file metadata without requiring explicit creation, aligning with the question's description. Temporary tables (B) are session-scoped and not tied to stages. Transient tables (C) are persistent but not stage-related. Tables with materialized views (D) are for query optimization and unrelated to stages. The community discussion shows 100% consensus on answer A with supporting documentation links.

Author: LeetQuiz Editorial Team