What are characteristics of transient tables in Snowflake? (Select TWO).

Question

Options

• ATransient tables have a Fail-safe period of 7 days.
• BTransient tables can be cloned to permanent tables.
• CTransient tables persist until they are explicitly dropped.
• DTransient tables can be altered to make them permanent tables.
• ETransient tables have Time Travel retention periods of 0 or 1 day.

• A
  6% (2)
• B
  91% (29)
• D
  3% (1)

Explanation

Two correct characteristics of transient tables are: (B) Transient tables can be cloned to permanent tables - Snowflake's CLONE operation supports creating permanent, transient, or temporary tables from a transient source, and (C) Transient tables persist until they are explicitly dropped - unlike temporary tables, which exist only for the duration of the session, transient tables survive across sessions and must be explicitly removed with DROP TABLE. Option A is wrong: transient tables have 0 days of Fail-safe (no Fail-safe protection at all). Option D is wrong: you cannot ALTER a table to change its type from transient to permanent after creation. Option E is technically true (transient tables support 0 or 1 day of Time Travel), but the exam identifies B and C as the two defining characteristics that distinguish transient from other table types.

No community discussion yet for this question.