Question 410
A test plan evaluates: A data engineer expects a temporary table created in one session to remain visible after the session ends. Which evidence should be required before release?
Explanation
Correct Answer
A cross-session access test finds the chosen persistent table; temporary table lifetime remains session-scoped. This validates the relevant action: Use a permanent or transient table if the intermediate results must outlive the session. The underlying Snowflake behavior is: Snowflake temporary tables are scoped to the creating session and are dropped at session end.
Incorrect Answers
The snapshot contains pre-delete rows while the current table retains its later changes. This evidence tests a DIFFERENT situation: A team wants a historical snapshot of a supported table at the state before a mistaken DELETE within retention. The correction required in this case is: Use a permanent or transient table if the intermediate results must outlive the session.
Time-filtered SQL queries prune eligible partitions without user-maintained folder partition definitions. This evidence tests a DIFFERENT situation: A table is manually partitioned into separate daily physical files to achieve traditional partition maintenance in regular Snowflake tables. The correction required in this case is: Use a permanent or transient table if the intermediate results must outlive the session.
A sample metadata refresh or write follows the chosen catalog ownership and supported permissions. This evidence tests a DIFFERENT situation: An application developer assumes an external Iceberg catalog table is administered identically to a native Snowflake-managed table. The correction required in this case is: Use a permanent or transient table if the intermediate results must outlive the session.