Explanation:
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.
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.