Exam SnowPro-Core Topic 4 Question 36 Discussion
Actual exam question for Snowflake's SnowPro-Core exam
Question #: 36
Topic #: 4
Question #: 36
Topic #: 4
What do temporary and transient tables have m common in Snowflake? (Select TWO).
Suggested Answer: A,D Vote an answer
Temporary and transient tables in Snowflake share several characteristics, notably, neither table type has a Fail-safe period. Fail-safe is a feature that provides additional data protection beyond the Time Travel period.
However, this feature does not apply to temporary or transient tables. Additionally, for both types of tables, the data retention period effectively ends when the tables are dropped. This means that once these tables are deleted, their data is not recoverable, distinguishing them from permanent tables, which benefit from Snowflake's Time Travel and Fail-safe features.References: Snowflake Documentation on Table Types
However, this feature does not apply to temporary or transient tables. Additionally, for both types of tables, the data retention period effectively ends when the tables are dropped. This means that once these tables are deleted, their data is not recoverable, distinguishing them from permanent tables, which benefit from Snowflake's Time Travel and Fail-safe features.References: Snowflake Documentation on Table Types
by gortali12 at Dec 07, 2025, 04:09 AM
Contact Us
If you have any question please leave me your email address, we will reply and send email to you in 12 hours.
Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday
Support: Contact now
Comments
gortali12
2025-12-07 04:09:52Upvoting 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.
Report Comment
Commenting
You can sign-up / login (it's free).