Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1016 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 1016
Topic #: 1
[All SnowPro Core Questions]

A user creates a stage using the following command:


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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
d22770a
1 month ago
Selected Answer: B
https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage After you create a stage with a directory table, you must execute ALTER STAGE … REFRESH to manually refresh the directory table metadata.
upvoted 1 times
...
Yiouk
5 months, 3 weeks ago
B. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage "Directory tables on internal stages require manual metadata refreshes." https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#label-directory-table-auto-refreshes "You can automatically refresh the metadata for a directory table by using the event messaging service for your cloud storage service."
upvoted 1 times
...
ahadh7621
5 months, 3 weeks ago
Selected Answer: B
Answer is B. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#label-directory-table-refreshes Directory tables on internal stages require manual metadata refreshes. This command creates an internal Snowflake stage since it doesn't specify an external cloud storage location. I ran this command in Snowflake and it was valid and using SHOW STAGES; I validated that it was an internal stage, so the answer is B
upvoted 3 times
...
icegrandpa
8 months, 1 week ago
Answer is A, test it in your snow account.
upvoted 2 times
...
NachoPrendes
8 months, 2 weeks ago
Selected Answer: A
Checked on Snowflake
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...