Answer-first summary for fast verification
Answer: An object layered on a stage that is used to store file-level metadata.
A directory table in Snowflake is an implicit object layered on a stage that stores file-level metadata about the data files in the stage. Option B is correct because it accurately describes this concept, aligning with Snowflake documentation which states directory tables are 'conceptually similar to an external table' and store file-level metadata. Option A is incorrect because directory tables are not separate database objects but are layered on stages. Option C is incorrect as directory tables are not primarily about grantable privileges for unstructured data tasks. Option D is incorrect because directory tables are not Snowflake tables designed for storing unstructured files themselves, but rather for storing metadata about files in stages.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a directory table in Snowflake?
A
A separate database object that is used to store file-level metadata.
B
An object layered on a stage that is used to store file-level metadata.
C
A database object with grantable privileges for unstructured data tasks.
D
A Snowflake table specifically designed for storing unstructured files.
No comments yet.