Snowpro Associate Platform · Free Practice Question Easy
Question 21
- A To back up data in real-time
- B To create an exact copy of a database, schema, or table without duplicating the storage
- C To manage user permissions
- D To create a backup of the entire Snowflake account
Reveal correct answer
Correct answer: B
Explanation
✅ To create an exact copy of a database, schema, or table without duplicating the storage
Explanation:
Snowflake's Cloning feature allows users to create a zero-copy replica of a database, schema, or table.
The cloned object shares the same underlying storage as the original, avoiding unnecessary duplication.
Changes made to the clone do not affect the original, and vice versa, unless explicitly modified.
This feature is useful for testing, development, and historical analysis without incurring additional storage costs.
❌ To back up data in real-time (Cloning is not a real-time backup solution; Time Travel is better suited for that)
❌ To manage user permissions (RBAC controls permissions, not cloning)
❌ To create a backup of the entire Snowflake account (Cloning works at the object level, not the full account level)
More details in Snowflake’s documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
