Question

A data engineer runs CREATE DATABASE analytics_dev CLONE analytics_prod; to give the development team a copy of production for testing. Shortly after, the team drops several tables in analytics_dev and adds new columns to others. A manager worries this experimentation could harm the production database. Which statement correctly describes the relationship between the cloned database and its source?

Accepted Answer

The clone is an independent object; changes to schemas and tables in analytics_dev do not affect analytics_prod, and cloned data initially shares underlying micro-partitions with the source at no extra storage cost.

Answer

The clone is a read-only reference to analytics_prod, so any attempt to drop tables in analytics_dev will fail with a permission error.

Answer

The clone physically duplicates all micro-partitions immediately, so it consumes the same storage as analytics_prod, but changes remain isolated from the source.

Answer

The clone stays synchronized with analytics_prod, so dropping tables in analytics_dev will also drop them in production unless the link is broken.