A data engineer creates a table in a Snowflake database that resides on a standard (non-replicated) storage. The engineer wants to confirm that Fail-safe will protect the table after Time Travel expires. Which table type should the engineer use?
Trap 1: External table
External tables reference data stored outside Snowflake, such as in a cloud storage bucket. Fail-safe does not apply to the external files, and the table object itself does not provide the same protection model as a permanent table. This option misapplies the Fail-safe concept to a table type that does not support it.
Trap 2: Transient table
Transient tables are designed for data that does not require long-term protection. They have Time Travel but no Fail-safe coverage, so once the retention window passes, the data is unrecoverable. This makes a transient table the wrong choice when Fail-safe protection is a requirement for the table in question.
Trap 3: Temporary table
Temporary tables exist only for the duration of a session and are dropped automatically when the session ends. They have minimal Time Travel and no Fail-safe. Choosing a temporary table would give the shortest possible lifespan and no post-retention protection, which contradicts the engineer's stated goal.
- A
External table
Why it fails: External tables reference data stored outside Snowflake, such as in a cloud storage bucket. Fail-safe does not apply to the external files, and the table object itself does not provide the same protection model as a permanent table. This option misapplies the Fail-safe concept to a table type that does not support it.
- B
Transient table
Why it fails: Transient tables are designed for data that does not require long-term protection. They have Time Travel but no Fail-safe coverage, so once the retention window passes, the data is unrecoverable. This makes a transient table the wrong choice when Fail-safe protection is a requirement for the table in question.
- C
Temporary table
Why it fails: Temporary tables exist only for the duration of a session and are dropped automatically when the session ends. They have minimal Time Travel and no Fail-safe. Choosing a temporary table would give the shortest possible lifespan and no post-retention protection, which contradicts the engineer's stated goal.
- D
Permanent table
Permanent tables are the only table type covered by Fail-safe. After the Time Travel retention period elapses, a 7-day Fail-safe window applies, during which Snowflake Support can assist with recovery. This matches the engineer's requirement for post-retention protection, making a permanent table the correct choice.