exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1343 discussion

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

What happens when a table or schema with a standard retention period is dropped?

  • A. The object is immediately removed from the system.
  • B. The object is instantaneously moved to Fail-safe.
  • C. The object is retained but all associated data is immediately purged.
  • D. The object is retained for the data retention period.
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
Billhardy
1 week, 5 days ago
Selected Answer: D
When you drop a table or schema in Snowflake that uses the standard Time Travel retention period, the object is not deleted immediately. Instead, it is retained in Snowflake’s Time Travel for the configured retention period (1 day by default in Standard Edition). During this window, you can restore the object using UNDROP. After Time Travel expires, permanent objects move into Fail‑Safe for an additional 7 days (recoverable only by Snowflake), and finally are purged permanently.
upvoted 1 times
...
37ceea2
3 months ago
Selected Answer: D
This time, I say D. It will be retain in the Time Travel, as per data retention period
upvoted 1 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