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.