AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company runs an Oracle database on premises. As part of the company's migration to AWS, the company wants to upgrade the database to the most recent available version. The company also wants to set up disaster recovery (DR) for the database. The company needs to minimize the operational overhead for normal operations and DR setup. The company also needs to maintain access to the database's underlying operating system.
Which solution will meet these requirements?
Other
Community
UAnonymous
A
Migrate the Oracle database to an Amazon EC2 instance. Set up database replication to a different AWS Region.
B
Migrate the Oracle database to Amazon RDS for Oracle. Activate Cross-Region automated backups to replicate the snapshots to another AWS Region.
C
Migrate the Oracle database to Amazon RDS Custom for Oracle. Create a read replica for the database in another AWS Region.
D
Migrate the Oracle database to Amazon RDS for Oracle. Create a standby database in another Availability Zone.
Explanation:
Explanation
Correct Answer: C - Migrate the Oracle database to Amazon RDS Custom for Oracle. Create a read replica for the database in another AWS Region.
Why this is correct:
-
Maintain access to the underlying operating system: This is the key requirement. Amazon RDS Custom for Oracle allows customers to access the underlying operating system and customize the database environment, unlike standard RDS for Oracle which is a managed service with restricted OS access.
-
Upgrade to the most recent available version: RDS Custom supports the latest Oracle database versions and allows customers to control the upgrade schedule.
-
Minimize operational overhead: RDS Custom provides automated backups, patching, and monitoring while still allowing OS-level access, reducing operational overhead compared to self-managed EC2 instances.
-
Disaster recovery setup: Creating a read replica in another AWS Region provides a disaster recovery solution with data replication across regions.
Why other options are incorrect:
A. EC2 instance with cross-region replication:
- Provides OS access ✓
- Allows database upgrades ✓
- However, this requires significant operational overhead for database management, backups, patching, and replication setup, which contradicts the requirement to minimize operational overhead.
B. RDS for Oracle with Cross-Region automated backups:
- Minimizes operational overhead ✓
- Provides disaster recovery via cross-region backups ✓
- BUT does not allow access to the underlying operating system, which is a key requirement.
D. RDS for Oracle with standby in another AZ:
- Minimizes operational overhead ✓
- Provides high availability within the same region ✓
- BUT does not provide cross-region disaster recovery (only within the same region)
- Does not allow access to the underlying operating system
Key AWS Services Understanding:
- RDS Custom: Managed database service that provides automated operations while allowing access to the underlying OS for customizations.
- RDS for Oracle: Fully managed service with no OS access.
- EC2: Complete control but maximum operational overhead.
- Read Replicas: Provide asynchronous replication for disaster recovery across regions.
This solution balances the need for OS access with minimized operational overhead while providing proper disaster recovery capabilities.
Comments
Loading comments...