1Z0-997-25 Question 42
Select 2Your company hosts a mission-critical financial application on Oracle Cloud Infrastructure (OCI) using multiple compute instances for the front-end and an Oracle Database back-end in a multi-AD region. The business requires a recovery time objective (RTO) of under five minutes and minimal data loss (RPO close to zero) if the primary region becomes unavailable. You are asked to design a disaster recovery strategy in a secondary region that ensures high availability and fast failover. Which two solutions would you implement to meet these objectives?
- A
- Create a standby database in the secondary region using Oracle Data Guard in Maximum Performance mode and enable automatic failover.
- B
- Store database data on NVMe local ephemeral drives for faster performance and rely on nightly object storage backups for DR.
- C
- Use Block Volume cross-region replication for critical file systems that store application configuration and logs.
- D
- Maintain daily on-premises backups and restore them manually in the secondary region if needed.
- E
- Configure Traffic Management Steering Policies (DNS failover) to direct users to the secondary region when the primary region is down.
Show answer and explanation
Correct answers: A, E
Explanation
To design a resilient and scalable disaster recovery solution with a minimal RTO and RPO, you should combine Oracle Data Guard for near real-time database replication and automatic failover with Traffic Management Steering Policies for DNS-based failover. This ensures that both the database and application routing fail over quickly. Data Guard is the recommended OCI DR approach for mission-critical databases, offering robust protection and minimal data loss. Refer to Oracle� Data Guard documentation and OCI Traffic Management best practices for detailed implementation steps.
- A. Correct.
Option 1: Correct. Oracle Data Guard in Maximum Performance mode strikes a good balance between performance and data protection, allowing nearly real-time asynchronous replication of the primary database to the standby. Enabling automatic failover (Fast-Start Failover) helps meet an RTO under five minutes and keeps RPO close to zero.
- B. Incorrect.
Option 2: Incorrect. NVMe local ephemeral storage is not replicated or persistent and cannot be directly mirrored to a secondary region. Relying solely on nightly backups for a mission-critical workload could lead to significant data loss and would not meet the low RTO/RPO requirements.
- C. Incorrect.
Option 3: Incorrect. While cross-region replication of block volumes is useful for file systems and certain application data, it does not alone ensure immediate failover of the database. For a database, Oracle Data Guard is the recommended solution to meet stringent RTO/RPO requirements.
- D. Incorrect.
Option 4: Incorrect. Relying on daily backups and manual restoration does not align with an RTO under five minutes. A manual restore process can be time-intensive and would introduce data loss risk.
- E. Correct.
Option 5: Correct. Using OCI Traffic Management Steering Policies (DNS failover) streamlines the switchover process, automatically directing client traffic to the secondary region when health checks detect a primary region outage. This is essential for meeting stringent RTO requirements.