SnowPro Core Certification — Question 784

What are characteristics of directory tables when used with unstructured data? (Choose two.)

Answer options

• A. Only cloud storage stages support directory tables.
• B. Each directory table has grantable privileges of its own.
• C. Directory tables store a catalog of staged files in cloud storage.
• D. A directory table can be added explicitly to a stage when the stage is created.
• E. A directory table is a separate database object that can be layered explicitly on a stage.

Correct answer: C, D

Explanation

The correct answers, C and D, highlight that directory tables maintain a catalog of staged files and can be explicitly added to a stage during its creation. Options A and E are incorrect as they either misrepresent the support for directory tables or their relationship with stages, while B is not relevant to the specific characteristics of directory tables with unstructured data.