Data Guard Replication for Migrating On-Premises Oracle Database to AWS

Answer: B.

Option A is incorrect because Amazon Aurora does not support Oracle.

Option B is CORRECT because to utilize Oracle Database Enterprise features on AWS, Amazon EC2 instances must be used for implementation.

Option C is incorrect because Amazon RDS Option Groups do not support Oracle Data Guard as an option for Oracle RDS databases.

Option D is incorrect because Amazon RDS Multi-AZ uses different technology than the high-availability technology provided by Oracle Data Guard.

Reference:

https://aws.amazon.com/rds/oracle/faqs/ https://docs.aws.amazon.com/quickstart/latest/oracle-database/overview.html

The correct answer is C. Implement Amazon RDS for Oracle with custom Options Group with Oracle Data Guard option configured.

Explanation: Oracle Data Guard is used for data replication in Oracle Database. To continue using this feature in AWS, we need to choose a solution that supports Oracle Data Guard.

Option A: Implement Amazon Aurora cluster with Aurora Replicas. Amazon Aurora is a MySQL and PostgreSQL-compatible relational database engine. It does not support Oracle Database or Oracle Data Guard, so this option is not suitable.

Option B: Implement Oracle Database cluster on EC2 instances. Running Oracle Database on EC2 instances can be complex and requires manual setup and management of servers, storage, and networking. Also, it does not provide built-in high availability or disaster recovery capabilities, so this option is not recommended.

Option C: Implement Amazon RDS for Oracle with custom Options Group with Oracle Data Guard option configured. Amazon RDS for Oracle provides a managed Oracle database service that automates time-consuming administrative tasks like hardware provisioning, database setup, patching, and backups. It supports Oracle Data Guard for replication and disaster recovery. Custom Options Groups allow you to configure advanced database options like Oracle Data Guard, which can be selected while creating the RDS instance. Therefore, this option is the best fit for the requirement.

Option D: Implement Amazon RDS for Oracle with Multi-AZ deployment. Multi-AZ deployment is a feature of Amazon RDS that provides high availability and automatic failover capabilities. It synchronously replicates data across multiple Availability Zones to provide redundancy and automatic failover. However, it does not provide the same level of control as Oracle Data Guard, so this option is not the best fit for the requirement.