Answer-first summary for fast verification
Answer: Directory tables store a catalog of staged files in cloud storage., A directory table can be added explicitly to a stage when the stage is created.
Based on the community discussion and Snowflake documentation, options C and D are correct. C is accurate because directory tables store file-level metadata about staged files in cloud storage, acting as a catalog. D is correct because directory tables can be explicitly added to a stage during creation. Option A is incorrect as directory tables are specific to cloud storage stages, but the phrasing 'only' is misleading. Option B is wrong because directory tables have no grantable privileges of their own. Option E is incorrect as directory tables are implicit objects tied to stages, not separate database objects that can be layered on stages.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which two statements accurately describe characteristics of directory tables when used with unstructured data?
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.