exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 394 discussion

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

What are the default Time Travel and Fail-safe retention periods for transient tables?

  • A. Time Travel - 1 day, Fail-safe - 1 day
  • B. Time Travel - 0 days, Fail-safe - 1 day
  • C. Time Travel - 1 day, Failsafe - 0 days
  • D. Transient tables are retained in neither Fail-safe nor Time Travel.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
halol
Highly Voted 1 year, 11 months ago
Selected Answer: C
Transient tables can have a Time Travel retention period of either 0 or 1 day. Temporary tables can also have a Time Travel retention period of 0 or 1 day; however, this retention period ends as soon as the table is dropped or the session in which the table was created ends. Transient and temporary tables have no Fail-safe period.
upvoted 5 times
...
_yyukta
Most Recent 8 months, 2 weeks ago
Selected Answer: C
C is correct
upvoted 1 times
...
MultiCloudIronMan
1 year, 3 months ago
Selected Answer: C
correct
upvoted 1 times
...
KeshavaMugulur
1 year, 11 months ago
it should be C
upvoted 4 times
...
Kate0204
1 year, 11 months ago
Selected Answer: C
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#comparison-of-table-types
upvoted 4 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