SG0-001 · Question #223
Asynchronous replication is defined as which of the following?
The correct answer is B. Data write is acknowledged to the host at the primary site only and then sent to secondary site. Asynchronous replication acknowledges data writes to the host immediately at the primary site, then transfers the data to the secondary site without waiting for its confirmation.
Question
Asynchronous replication is defined as which of the following?
Options
- AData write is acknowledged to the host at the secondary site only, and then sent to primary site
- BData write is acknowledged to the host at the primary site only and then sent to secondary site
- CData write is not acknowledged to the host until transfer has been verified by secondary
- DData write is acknowledged to the host at both primary and secondary simultaneous^ and
How the community answered
(21 responses)- A5% (1)
- B90% (19)
- D5% (1)
Why each option
Asynchronous replication acknowledges data writes to the host immediately at the primary site, then transfers the data to the secondary site without waiting for its confirmation.
This scenario describes an unusual or inverse replication model, not standard asynchronous replication where the primary site is the source.
In asynchronous replication, the primary storage system acknowledges the data write to the application host immediately after writing the data locally. The data is then replicated to the secondary site in the background, without the primary site waiting for confirmation from the secondary, thus minimizing latency impacts on the primary application.
This describes synchronous replication, where the primary site waits for the secondary site to confirm receipt and write of data before acknowledging the write to the host.
This is inaccurate; acknowledgment happens from the primary, and in synchronous replication, it waits for secondary confirmation. Simultaneous acknowledgment from both to the host is not how replication typically functions.
Concept tested: Asynchronous data replication
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-overview-architecture?view=azuresql
Topics
Community Discussion
No community discussion yet for this question.