What happens when a cloned table is replicated to a secondary database? (Select TWO)

What happens when a cloned table is replicated to a secondary database? (Select TWO)
A . A read-only copy of the cloned tables is stored.
B. The replication will not be successful.
C. The physical data is replicated
D. Additional costs for storage are charged to a secondary account
E. Metadata pointers to cloned tables are replicated

View Answer

Answer: A E

Explanation:

When a cloned table is replicated to a secondary database in Snowflake, the following occurs:

A read-only copy of the cloned tables is stored in the secondary database. This ensures that the replicated data is consistent with the primary database and can be used for reporting, querying, or other read-only operations.

Metadata pointers to cloned tables are replicated, rather than the physical data. Snowflake’s cloning operation is metadata-based, which means that cloning a table does not create a full copy of the data. Instead, the new table references the same underlying data as the original table. When replicating a cloned table, Snowflake replicates these metadata pointers, ensuring efficient replication without duplicating the physical data.