A snapshot of the primary database's objects and data is transferred to the secondary database during replication.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

A snapshot of the primary database's objects and data is transferred to the secondary database during replication.

Explanation:
In replication, a baseline is created by sending a snapshot of the primary database’s current objects and data to the secondary. This initial transfer establishes an identical starting point—the secondary receives both the schema (objects) and the data so it can represent the exact state of the primary at that moment. Once this baseline is in place, ongoing changes from the primary are captured and applied to the secondary to keep them in sync. If only metadata were transferred, or no snapshot were sent, the secondary wouldn’t reflect the actual data or would lack the necessary structures to receive updates. That’s why this statement is true.

In replication, a baseline is created by sending a snapshot of the primary database’s current objects and data to the secondary. This initial transfer establishes an identical starting point—the secondary receives both the schema (objects) and the data so it can represent the exact state of the primary at that moment. Once this baseline is in place, ongoing changes from the primary are captured and applied to the secondary to keep them in sync. If only metadata were transferred, or no snapshot were sent, the secondary wouldn’t reflect the actual data or would lack the necessary structures to receive updates. That’s why this statement is true.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy