SnowPro Core Certification — Question 1059

What is a directory table in Snowflake?

Answer options

• A. A separate database object that is used to store file-level metadata.
• B. An object layered on a stage that is used to store file-level metadata.
• C. A database object with grantable privileges for unstructured data tasks.
• D. A Snowflake table specifically designed for storing unstructured files.

Correct answer: B

Explanation

The correct answer, B, accurately describes a directory table as an object that is built upon a stage to manage file-level metadata. Option A is incorrect because it implies a separate database object rather than being associated with a stage. Option C is not correct since it refers to grantable privileges, which is not the primary function of a directory table. Option D mischaracterizes the purpose of the directory table, as it is not designed specifically for storing unstructured files.