Answer: Directory tables store file-level metadata about the data files in a stage., A directory table can be added to a stage when the stage is created, or later.

Based on the community discussion and Snowflake documentation, options D and E are correct. D is correct because directory tables store file-level metadata (e.g., file URLs, sizes, last modified timestamps) about data files in a stage, not the actual file content. E is correct because directory tables can be added to a stage during creation (using the DIRECTORY = (ENABLE = TRUE) parameter) or later (using ALTER STAGE). Option A is incorrect because directory tables are not separate database objects; they are metadata views tied to a stage. Option B is incorrect because directory tables work with both internal and external stages. Option C is incorrect because directory tables do not store copies of staged files in binary format; they only store metadata references.

Author: LeetQuiz Editorial Team