The correct answer is B. Directory table .
A directory table stores file-level metadata for files in a Snowflake stage. It can be used to see a list of files available in an internal or external stage.
Why B is correct:
Directory tables allow users to query staged file metadata, including file path, file size, last modified timestamp, and file URL information.
Example:
SELECT *
FROM DIRECTORY(@my_stage);
This returns metadata for files stored in the stage.
Why the other options are incorrect:
A. A semantic view is used to define business-friendly semantic relationships for analytics, not to list staged files.
C. A materialized view stores precomputed query results, not stage file metadata.
D. Information Schema contains metadata about Snowflake objects, but the Snowflake object specifically designed to list files in a stage is a directory table.
Official Snowflake documentation reference:
Snowflake documentation describes directory tables as objects that store a catalog of staged files in cloud storage.
[Reference: Snowflake Documentation — Directory tables; Snowflake Documentation — Stages; SnowPro Core Study Guide — Data Loading and Unloading., ========================]
Submit