SnowPro Core Certification — Question 985

A user creates a stage using the following command:

CREATE STAGE mystage -
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;

What will be the outcome?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because the command creates a stage with a directory table that requires manual refresh of its metadata due to the specified settings. Option A is incorrect as it implies automatic refresh, which is not true in this case. Options C and D are also incorrect because the command is valid despite not specifying a storage location or directory table name.