What are characteristics of transient tables in Snowflake? (Choose two.)
What are characteristics of transient tables in Snowflake? (Choose two.)
Transient tables in Snowflake have specific characteristics. They persist until they are explicitly dropped, differentiating them from temporary tables which are automatically dropped at the end of a session. Additionally, transient tables have Time Travel retention periods of either 0 or 1 day, as they are designed for scenarios where the data does not need long-term retention or extensive recovery options. They do not have a Fail-safe period, and they cannot be cloned to permanent tables or altered to become permanent.
Transient tables are a type of table in Snowflake that persist until they are explicitly dropped. They do not have a Fail-safe period, and they can only have a Time Travel retention period of 0 or 1 day. Transient tables cannot be cloned to permanent tables, and they cannot be altered to make them permanent tables.
see the comparison of table types - https://docs.snowflake.com/en/user-guide/tables-temp-transient
B does not make sense.
Transient => Temporary Transient => Transient
correct https://docs.snowflake.com/user-guide/tables-temp-transient#comparison-of-table-types
https://www.bing.com/search?q=What+are+characteristics+of+transient+tables+in+Snowflake%3F&qs=n&form=QBRE&sp=-1&lq=0&pq=what+are+characteristics+of+transient+tables+in+snowflake%3F&sc=1-58&sk=&cvid=82C0B06F8F6B402FABAB2E7EC1CFAAAF&ghsh=0&ghacc=0&ghpl=
Answer is C & E