exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 975 discussion

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

How can a dropped internal stage be restored?

  • A. Enable Time Travel.
  • B. Clone the dropped stage.
  • C. Execute the UNDROP command.
  • D. Recreate the dropped stage.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
aral
3 weeks, 6 days ago
Selected Answer: D
From docs https://docs.snowflake.com/en/sql-reference/sql/drop-stage#:~:text=Usage%20notes,must%20be%20recreated.
upvoted 1 times
...
aemilka
2 months ago
Selected Answer: D
Dropped stages cannot be recovered; they must be recreated.
upvoted 1 times
...
SnowProAdv
6 months, 2 weeks ago
In Snowflake, a dropped internal stage can be restored using the UNDROP command, provided that it is within the Time Travel retention period.
upvoted 1 times
...
nicholascz
7 months, 1 week ago
D https://community.snowflake.com/s/question/0D5Do00000IaDSDKA3/if-the-internal-stage-is-forcibly-dropped-can-snowflakes-support-team-recover-it-to-failsafe-functionality
upvoted 1 times
...
0e504b5
10 months, 1 week ago
Selected Answer: D
D. Recreate the dropped stage. https://docs.snowflake.com/en/user-guide/data-time-travel#introduction-to-time-travel Using Time Travel, you can perform the following actions within a defined period of time: Query data in the past that has since been updated or deleted. Create clones of entire tables, schemas, and databases at or before specific points in the past. Restore tables, schemas, and databases that have been dropped. Doesn't look like you can restore a dropped stage using UNDROP and time travel. Looks like you just need to recreate it using your SQL definition.
upvoted 1 times
0e504b5
10 months, 1 week ago
Confirmed that C is not possible: USE ROLE SYSADMIN; USE DATABASE TIME_TRAVEL_TEST; USE SCHEMA PUBLIC; CREATE STAGE images_stage URL = 's3://photos/national_parks/us/yosemite/'; SELECT GET_STAGE_LOCATION(@images_stage); SHOW PARAMETERS like '%DATA_RETENTION_TIME_IN_DAYS%' in schema PUBLIC; DROP STAGE images_stage; UNDROP STAGE images_stage; ---000002 (0A000): Unsupported feature 'UNDROP not supported for objects of type STAGE'.
upvoted 1 times
icegrandpa
9 months, 2 weeks ago
you are using an external stage in this example.
upvoted 1 times
...
0e504b5
10 months, 1 week ago
https://docs.snowflake.com/en/sql-reference/sql/undrop You can undrop DB, SCHEMA, TABLE, also ACCOUNT and TAG
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago