Question 330
A test plan evaluates: A staging team creates transient tables for reproducible data but expects the seven-day Fail-safe recovery of permanent tables. Which evidence should be required before release?
Explanation
Correct Answer
The chosen permanent table has documented Fail-safe coverage while transient test tables do not. This validates the relevant action: Use permanent tables when extended platform recovery protection is required; reserve transient for rebuildable data. The underlying Snowflake behavior is: Transient tables do not have Fail-safe and have more limited Time Travel retention.
Incorrect Answers
The selected retention setting is accepted without unsupported edition assumptions. This evidence tests a DIFFERENT situation: A team increases Time Travel retention to 90 days on a Standard Edition account without checking edition limits. The correction required in this case is: Use permanent tables when extended platform recovery protection is required; reserve transient for rebuildable data.
A region-level outage drill has an independent approved recovery path rather than relying on a local clone. This evidence tests a DIFFERENT situation: A data steward uses a zero-copy clone as a replacement for a remote recovery copy in a separate cloud region. The correction required in this case is: Use permanent tables when extended platform recovery protection is required; reserve transient for rebuildable data.
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 permanent tables when extended platform recovery protection is required; reserve transient for rebuildable data.