Answer: Directory

The correct answer is A (Directory) because directory tables in Snowflake are specifically designed to store file-level metadata for each file in a stage. According to the community discussion and Snowflake documentation referenced, directory tables maintain metadata such as file names, sizes, last modified dates, and other file attributes for all files in a stage. The other options are incorrect: B (External) refers to tables that query data stored externally in cloud storage, C (Temporary) are session-scoped tables that persist only for the duration of a user session, and D (Transient) are tables that do not have the same data protection as permanent tables but are not specifically for stage file metadata.

Author: LeetQuiz Editorial Team