SnowPro Core Certification — Question 1066

What is the primary purpose of a directory table in Snowflake?

Answer options

• A. To store actual data from external stages
• B. To automatically expire file URLs for security
• C. To manage user privileges and access control
• D. To store file-level metadata about data files in a stage

Correct answer: D

Explanation

The correct answer, D, accurately describes that a directory table stores file-level metadata about data files in a stage, which is crucial for managing and accessing data. Options A, B, and C are incorrect because they pertain to other functionalities that are not related to the specific role of a directory table in Snowflake.