SOL-C01 practice question 23 of 30
How do you enable a Directory Table for an external stage in Snowflake?
Full set: 214 questionsDirectory tables are not enabled by default on external stages. To enable this feature, which allows you to query a catalog of staged files, you must explicitly set a parameter on the stage. The correct method is to use the ALTER STAGE command to modify an existing stage or include the parameter during the CREATE STAGE command. The parameter ENABLEDIRECTORYTABLE (or the newer DIRECTORY = (ENABLE = TRUE)) must be set to TRUE.
A. By default, Directory Tables are enabled: This is incorrect. The feature must be explicitly enabled to avoid the overhead of file cataloging if not needed.
B. Using the command CREATE DIRECTORY TABLE ...: This is not a valid Snowflake SQL command. Directory tables are a property of a stage, not a standalone object.
D. By creating a view on the external stage: A view is a logical representation of a query and cannot be used to configure the underlying properties of a stage.
Snowflake Documentation, "CREATE STAGE". The documentation lists ENABLEDIRECTORYTABLE = TRUE | FALSE as one of the optional stageparams for creating a stage.
Snowflake Documentation, "ALTER STAGE". This page documents the syntax for modifying a stage, including ALTER STAGE ... SET ENABLEDIRECTORYTABLE = TRUE.
Snowflake Documentation, "Directory Tables". The section "Enabling Directory Tables" explicitly states that the feature must be enabled on a stage.
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
