SnowPro Core Certification — Question 863

What are characteristics of Snowflake directory fables? (Choose two.)

Answer options

• A. Directory tables are separate database objects.
• B. Directory tables can only be used with an external stage.
• C. Directory tables contain copies of staged files in binary format.
• D. Directory tables store file-level metadata about the data files in a stage.
• E. A directory table can be added to a stage when the stage is created, or later.

Correct answer: D, E

Explanation

The correct answers are D and E because directory tables are designed to hold file-level metadata about data files in a stage, and they can be added to a stage either during its creation or at a later time. Options A, B, and C are incorrect as they misrepresent the purpose and usage of directory tables in Snowflake.