Question 50
A database contains critical customer records where short-lived transient protections are insufficient. Which table type is safest?
Explanation
Correct Answer
Correct: permanent storage includes the standard recovery lifecycle. Permanent Snowflake table retains standard Time Travel and Fail-safe protection for durable managed data.
Incorrect Answers
Not the best choice: Transient Snowflake table persists across sessions but has no Fail-safe window; the scenario instead requires permanent storage includes the standard recovery lifecycle.
Not the best choice: Temporary Snowflake table exists only for the session that created it; the scenario instead requires permanent storage includes the standard recovery lifecycle.
Not the best choice: Apache Iceberg table exposes an open table format and metadata model rather than only Snowflake-native managed storage; the scenario instead requires permanent storage includes the standard recovery lifecycle.