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

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.

A. Migrate the Oracle database to an Amazon EC2 instance. Set up database replication to a different AWS Region. Explanation: Migrating the Oracle database to an Amazon EC2 instance allows the company to maintain full control over the database, including access to the underlying operating system. Setting up database replication to a different AWS Region ensures disaster recovery with minimal operational overhead.

Has to be C, since they need access to the OS: “ require access to the underlying OS and DB environment” https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-rds-custom-oracle/

"The company also needs to maintain access to the database's underlying operating system"