Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 133 discussion

Option C since RDS Custom has access to the underlying OS and it provides less operational overhead. Also, a read replica in another Region can be used for DR activities. https://aws.amazon.com/blogs/database/implementing-a-disaster-recovery-strategy-with-amazon-rds/

It should be C: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-custom.html and https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/working-with-custom-oracle.html

A: Incorrect - Question states to minimise operational overhead, building an EC2 instance and managing that doesn't reduce the operational overhead. B: Incorrect - Yes that ticks the DR aspect, but Amazon RDS for Oracle doesn't provide access to the underlying operating system of the database server. C: Correct - Amazon RDS Custom provides a limited amount of operating system access of the database server(s), so that's good. Creating a read replica in another AWS Region covers DR. Its not asking for High Availability (HA) in this case. D: Incorrect - Amazon RDS for Oracle doesn't provide access to the underlying operating system of the database server. A standby database in another availability, could be considered as covering DR.

Amazon RDS Custom for Oracle is the best choice because it allows access to the underlying OS, provides an easier path for upgrades, minimizes operational overhead, and supports setting up cross-region read replicas for a DR solution.

It should be standby: . When the primary database fails, Amazon RDS promotes the secondary database to primary. Because it assumes the primary databases endpoint, the EC2 instances can resume traffic with the new primary database. Meanwhile, a new standby database is created in the other Availability Zone.

Ans D - use regular RDS Oracle; no need for RDS Custom because the question doesn't state and special customisations... the only bit unanswered is "...maintain access to company's underlying o/s"

Option C provides the right balance of managed service convenience, access to the underlying OS, and effective disaster recovery with cross-region read replicas

"You can't create cross-Region RDS Custom for Oracle replicas." So it can't be C. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-rr.html B and D don't provide access to underlying OS. So the only option left is A, which won't help minimize the operational overhead though.

B, D - do not have access to underlying OS. Both A and C could work, but C is less Overhead. C - Amazon RDS Custom for Oracle actually supports creating read replicas. "Creating an RDS Custom for Oracle replica is similar to creating an RDS for Oracle replica, but with important differences." (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-rr.html). The read replica is not meant for disaster recovery, but it could work as such when no better options are available.

You can't create cross-Region RDS Custom for Oracle replicas.

Since we need to have access to the underlying infrastructure, C makes sense.

Its C Key : Access to underlying O.S - RDS custom can give you this feature General RDS for Oracle( or any) - you can't access underlying O.S So, definitely C considering this point in the question

Defintely not C. You cannot create a read replica of RDS custom for Oracle in a different region: https://aws.amazon.com/blogs/database/build-high-availability-for-amazon-rds-custom-for-oracle-using-read-replicas/

C for sure

Answer C is not correct as cross-Region replicas in RDS Custom for Oracle are not allowed as stated by a previous answe. Correct answer: B https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReplicateBackups.html Low operational overhead since the backup is automated.

RDS Custom

C. Migrate the Oracle database to Amazon RDS Custom for Oracle. Create a read replica for the database in another AWS Region. Explanation: Amazon RDS Custom for Oracle: Amazon RDS Custom for Oracle allows the company to run Oracle databases on managed instances in the AWS Cloud. It provides managed services for tasks such as backups, patching, and monitoring, minimizing operational overhead for normal operations. Read Replica in Another AWS Region: By creating a read replica for the database in another AWS Region, the company can set up disaster recovery (DR) with minimal operational overhead. Amazon RDS automatically handles replication between the primary database and the read replica, ensuring data consistency and minimizing management tasks for DR setup.