Answer-first summary for fast verification
Answer: Directory tables store data file metadata., Directory tables do not have their own grantable privileges.
Based on the community discussion and Snowflake documentation, options B and D are correct. B is correct because directory tables store metadata about data files, including file names, sizes, and last modified timestamps, which is essential for managing unstructured data. D is correct because directory tables do not have their own grantable privileges; access is controlled through the underlying stage's privileges. Option A is incorrect as directory tables are not separate database objects but implicit objects layered on stages. Option C is incorrect because directory tables are not automatically added to stages; they must be explicitly created using CREATE or ALTER STAGE. Option E is incorrect as directory table data can be manually refreshed using ALTER STAGE ... REFRESH.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following are considerations when using a directory table for unstructured data? (Choose two.)
A
A directory table is a separate database object.
B
Directory tables store data file metadata.
C
A directory table will be automatically added to a stage.
D
Directory tables do not have their own grantable privileges.
E
Directory table data can not be refreshed manually.
No comments yet.