1Z0-1151-25 Question 104
Single answerYour organization runs an Oracle Database on Azure and uses OCI as a disaster recovery (DR) site. You have established Oracle-Azure Interconnect for low-latency, high-bandwidth connectivity between the clouds. The business requires near-zero data loss and automatic failover in case the Azure environment becomes unavailable. Which Oracle Data Guard protection mode best meets these requirements?
- A
Deploy Oracle Data Guard with Maximum Protection using synchronous redo shipping
- B
Deploy Oracle Data Guard with Maximum Availability using synchronous redo shipping
- C
Deploy Oracle Data Guard with Maximum Performance using asynchronous redo shipping
- D
Use Oracle GoldenGate for incremental replication of transactions to the OCI standby database
Show answer and explanation
Correct answer: B
Explanation
In a multi-cloud scenario where near-zero data loss and automatic failover are top priorities, Maximum Availability mode with synchronous redo shipping is the preferred approach. It strikes a balance between strict data protection (like Maximum Protection) and the ability to continue operations if connectivity issues arise. Configuring Fast-Start Failover allows automatic failover to the standby in OCI when the primary on Azure becomes unavailable. For further details, consult Oracle Data Guard documentation regarding protection modes, networking requirements, and failover configurations.
- A. Incorrect.
Option 1: Maximum Protection ensures zero data loss by shutting down the primary if it cannot write to the standby. While it guarantees no data loss, it may be too restrictive for certain production environments because even brief network interruptions cause the primary to fail, impacting availability.
- B. Correct.
Option 2: Maximum Availability with synchronous redo shipping aims for zero data loss while allowing the primary to continue if conditions temporarily prevent synchronous writes. This mode balances data protection and availability, and it supports automatic failover when configured with Fast-Start Failover. It meets the near-zero data loss and automatic failover requirements in a well-connected environment like Oracle-Azure Interconnect.
- C. Incorrect.
Option 3: Maximum Performance uses asynchronous redo transport, which typically introduces the possibility of some data loss if the primary fails. Although it minimizes performance impact, it does not guarantee near-zero data loss.
- D. Incorrect.
Option 4: Oracle GoldenGate is a real-time data replication solution but is typically used for broader data integration or heterogeneous replication scenarios. In this case, Data Guard is the recommended choice for integrated failover and high availability for Oracle Databases.