Answer-first summary for fast verification
Answer: A stage with a directory table that has metadata that must be manually refreshed will be created.
The CREATE STAGE command creates an internal stage since no external storage location is specified. When DIRECTORY = (ENABLE = TRUE) is used without AUTO_REFRESH = TRUE, it creates a directory table that requires manual metadata refreshes using ALTER STAGE ... REFRESH. This is confirmed by Snowflake documentation stating that directory tables on internal stages require manual metadata refreshes, and auto-refresh is only available for external stages using cloud storage event messaging services. The community discussion shows strong consensus for option B (75% of votes), with multiple users citing official documentation and practical testing. Option A is incorrect because auto-refresh is not enabled by default and is not supported for internal stages. Options C and D are incorrect because the command syntax is valid and executes successfully.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user creates a stage using the following command:
CREATE STAGE mystage
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;
CREATE STAGE mystage
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;
What will be the outcome?
A
A stage with a directory table set to automatically refresh will be created.
B
A stage with a directory table that has metadata that must be manually refreshed will be created.
C
An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
D
The command will fail to run because the name of the directory table is not specified.
No comments yet.