Question #1152
A company operates an on-premises Oracle database and plans to migrate to AWS. The company aims to upgrade the database to the latest version and establish a disaster recovery (DR) solution. The solution must minimize operational overhead for daily operations and DR setup while retaining access to the database's underlying operating system.
Which solution meets these requirements?
Migrate the Oracle database to an Amazon EC2 instance. Configure Oracle Data Guard for cross-Region replication.
Migrate the Oracle database to Amazon RDS for Oracle. Use Cross-Region automated backups for DR.
Migrate the Oracle database to Amazon RDS Custom for Oracle. Deploy a cross-Region read replica for DR.
Migrate the Oracle database to Amazon RDS for Oracle. Implement a Multi-AZ deployment for high availability.
Explanation
Option C is correct because:
1. Amazon RDS Custom for Oracle provides managed database services while retaining access to the underlying OS, satisfying the requirement for OS-level access.
2. Cross-Region read replicas automate DR setup, reducing operational overhead compared to manual solutions like Oracle Data Guard (Option A).
Other options fail because:
- A (EC2 + Data Guard): Requires manual management of infrastructure and DR, increasing operational overhead.
- B (RDS + Cross-Region backups): RDS restricts OS access, violating the requirement.
- D (RDS Multi-AZ): Multi-AZ only provides intra-region HA, not cross-region DR, and lacks OS access.
Key Points:
- Use RDS Custom when OS access is required with managed services.
- Cross-Region read replicas automate DR for RDS Custom/Oracle.
Answer
The correct answer is: C