Question 340
One analyst needs scratch records that should disappear at session end. Which table type fits?
Explanation
Correct Answer
Correct: session-bound data. Temporary table is limited to the lifetime of the creating session.
Incorrect Answers
Incorrect: Time Travel retention parameter determines the available historical query/recovery interval for eligible objects; this case calls for session-bound data.
Incorrect: Fail-safe is a Snowflake-managed additional recovery period for permanent table data; this case calls for session-bound data.
Incorrect: Transient table avoids the Fail-safe period for reconstructable persistent data; this case calls for session-bound data.