exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 301 discussion

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

What happens when an external or an internal stage is dropped? (Choose two.)

  • A. When dropping an external stage, the files are not removed and only the stage is dropped.
  • B. When dropping an external stage, both the stage and the files within the stage are removed.
  • C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable.
  • D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable.
  • E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

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
SV1122
Highly Voted 1 year, 10 months ago
Selected Answer: AD
For an internal stage, all of the files in the stage are purged from Snowflake, regardless of their load status. This prevents the files from continuing to using storage and, consequently, accruing storage charges. However, this also means that the staged files cannot be recovered after a stage is dropped. For an external stage, only the stage itself is dropped; any data files in the referenced external location (Amazon S3, Google Cloud Storage, or Microsoft Azure) are not removed. https://docs.snowflake.com/en/sql-reference/sql/drop-stage.html#drop-stage
upvoted 9 times
...
_yyukta
Most Recent 8 months, 2 weeks ago
Selected Answer: AD
AD are correct
upvoted 1 times
...
Marge23
1 year, 1 month ago
Selected Answer: AD
correct
upvoted 1 times
...
MultiCloudIronMan
1 year, 3 months ago
Selected Answer: AD
correct
upvoted 1 times
...
imhm24
1 year, 5 months ago
Selected Answer: AD
per the docs explain
upvoted 2 times
...
sakis213
1 year, 10 months ago
Selected Answer: AD
per the docs explain
upvoted 2 times
...
halol
1 year, 11 months ago
https://docs.snowflake.com/en/sql-reference/sql/drop-stage.html#drop-stage
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