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: C, E

Explanation:

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

C. The physical data is replicated: The actual data of the cloned table is physically replicated to the secondary database. This ensures that the secondary database has its own copy of the data, which can be used for read-only purposes or failover scenarios1.

E. Metadata pointers to cloned tables are replicated: Along with the physical data, the metadata pointers that refer to the cloned tables are also replicated. This metadata includes information about the structure of the table and any associated properties2.

It’s important to note that while the physical data and metadata are replicated, the secondary database is typically read-only and cannot be used for write operations. Additionally, while there may be additional storage costs associated with the secondary account, this is not a direct result of the replication process but rather a consequence of storing additional data.

Reference: SnowPro Core Exam Prep ― Answers to Snowflake’s LEVEL UP: Backup and Recovery Snowflake SnowPro Core Certification Exam Questions Set 10