Question 470
An organization running Snowflake reports: A QA team needs a safe test copy of a large production schema but rejects cloning because it expects an immediate full storage duplication. Which validation result best demonstrates that the reported defect is resolved?
Explanation
Correct Answer
This verifies zero-copy clone because zero-copy cloning can reuse existing micro-partitions until changes create new storage. The corresponding corrective action is: Create an authorized zero-copy clone for the isolated test requirement. A green status for a different component would not independently establish this result.
Incorrect Answers
Importing a share does not automatically grant every consumer role usage and select privileges. “Grant approved imported-database privileges through the consumer's authorized roles” would address that alternative cause, not the condition in this question: zero-copy cloning can reuse existing micro-partitions until changes create new storage.
“Use appropriately configured Time Travel or backups for ordinary historical recovery needs” responds to this separate finding: fail-safe is a last-resort recovery mechanism rather than a routine user query feature. This question instead needs “Create an authorized zero-copy clone for the isolated test requirement”, so the alternative does not meet the stated condition.
Clones become independent logical objects whose later data changes do not automatically propagate. “Keep development writes in the cloned object and verify source and clone identities before execution” applies to that separate problem. The observed case is a QA team needs a safe test copy of a large production schema but rejects cloning because it expects an immediate full storage duplication; choosing this alternative would address the wrong failure mode.