1Z0-997-25 Question 32
Single answerYou are designing a mission-critical application on Oracle Cloud Infrastructure that must achieve near-zero data loss (RPO ≈ 0) and automatic failover if the primary region becomes unavailable. The application� backend runs on an Oracle Database. Which approach best meets these requirements?
- A
Deploy your Oracle Database and application tiers in a single Availability Domain with local backups and rely on manual failover.
- B
Use Active Data Guard within the same region across two Availability Domains with asynchronous redo transport.
- C
Use Active Data Guard across two regions configured in Maximum Availability or Maximum Protection mode with an observer for automatic failover.
- D
Rely exclusively on block volume cross-region replication for data synchronization, without configuring a Database Data Guard standby.
Show answer and explanation
Correct answer: C
Explanation
For highly critical workloads needing near-zero data loss and automated failover, using Active Data Guard in Maximum Availability or Maximum Protection mode across two regions is a recommended architecture. Synchronous (or near-synchronous) redo transport ensures minimal data loss, and the observer process can initiate automatic failover if the primary region becomes unavailable. Refer to Oracle Cloud Infrastructure Data Guard documentation for details on configuring Maximum Availability or Maximum Protection modes in multi-region deployments.
- A. Incorrect.
Incorrect. While local backups can be used for restoring data, they do not support near-zero data loss or automatic failover. In a regional outage scenario, you would have to perform a manual restore in another region, which increases RTO.
- B. Incorrect.
Incorrect. Active Data Guard across Availability Domains in the same region helps if a single Availability Domain fails. However, if the entire region is impacted, this setup does not address region-wide DR. Also, asynchronous redo transport cannot guarantee near-zero data loss.
- C. Correct.
Correct. Configuring Active Data Guard with synchronous (or near-synchronous) redo transport in Maximum Protection or Maximum Availability mode across regions ensures minimal data loss. The Data Guard observer can provide automatic failover, meeting both the near-zero RPO and low RTO requirements.
- D. Incorrect.
Incorrect. Cross-region replication for block volumes helps replicate storage data but does not provide the database-level features like continuous redo apply and automated failover. You need a proper standby database with Active Data Guard to meet near-zero RPO and automated failover.