
Explanation:
The question asks for three common use cases of zero-copy cloning in Snowflake. Zero-copy cloning creates a copy of a database, schema, or table that shares the underlying storage with the original, making it efficient for specific scenarios. Option A (Quick provisioning of Dev and Test/QA environments) is correct because cloning allows rapid setup of isolated environments without duplicating data. Option B (Data backups) is supported as clones serve as logical backups, preserving data at a point in time, though they are not physical backups. Option C (Point in time snapshots) is correct because cloning captures the state of data at a specific moment, enabling recovery or analysis. Option D (Performance optimization) is incorrect, as cloning itself does not enhance performance; it may even introduce overhead if not managed properly. The community discussion, with multiple comments and upvotes favoring ABC, reinforces this reasoning, noting that cloning is not intended for optimization.
Ultimate access to all questions.
No comments yet.