nerdexam
Snowflake

COF-R02 · Question #112

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

The correct answer is C. The physical data is replicated D. Additional costs for storage are charged to a secondary account. Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned…

Continuous Data Protection

Question

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

Options

  • AA read-only copy of the cloned tables is stored.
  • BThe replication will not be successful.
  • CThe physical data is replicated
  • DAdditional costs for storage are charged to a secondary account
  • EMetadata pointers to cloned tables are replicated

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    79% (19)
  • E
    13% (3)

Explanation

Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.

Topics

#zero-copy clone#replication#secondary database

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice