What are characteristics of transient tables in Snowflake? (Select TWO).
A.
Transient tables have a Fail-safe period of 7 days.
B.
Transient tables can be cloned to permanent tables.
C.
Transient tables persist until they are explicitly dropped.
D.
Transient tables can be altered to make them permanent tables.
E.
Transient tables have Time Travel retention periods of 0 or 1 day.
The Answer Is:
B, C
This question includes an explanation.
Explanation:
Transient tables in Snowflake are designed for temporary or intermediate workloads with the following characteristics:
B. Transient tables can be cloned to permanent tables: This feature allows users to create copies of transient tables for permanent use, providing flexibility in managing data lifecycles.
C. Transient tables persist until they are explicitly dropped: Unlike temporary tables that exist for the duration of a session, transient tables remain in the database until explicitly removed by a user, offering more durability for short-term data storage needs.
References:
Snowflake Documentation: Transient Tables
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"