Its D Multi-AZ DB clusters aren't available with the following engines: RDS for MariaDB RDS for Oracle RDS for SQL Server https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.MultiAZDBClusters.html

Selected Answer: C C. Use Amazon RDS deployed in a Multi-AZ cluster deployment to create an Oracle database. Send the reporting functions to use the reader instance in the cluster deployment. A and B discarted. The answer is between C and D D says use an Amazon RDS to build an Amazon Aurora, makes no sense. C is the correct one, high availability in multi az deployment. Also point the reporting to the reader replica.

Multi-AZ DB clusters aren't available with the following engines: RDS for MariaDB RDS for Oracle RDS for SQL Server

Multi-AZ (Availability Zone) deployments are not available for the following Amazon RDS database engines: 1. Amazon Aurora with MySQL compatibility 2. Amazon Aurora with PostgreSQL compatibility 3. Amazon RDS for SQL Server Express Edition 4. Amazon RDS for Oracle Standard Edition One 5. Amazon RDS for Oracle Standard Edition 6. Amazon RDS for Oracle SE2 (Standard Edition 2) For these database engines, Amazon RDS provides high availability using other mechanisms specific to each engine, such as Read Replicas or different standby configurations. However, Multi-AZ deployments, which automatically provision and maintain a synchronous standby replica in a different Availability Zone for failover support, are not supported for these engines.

You can use Aurora instead of Oracle. There are tutorials how to migrate Oracle to Aurora. On top C is not supported. The is not Multi-AZ DB CLUSTER for Oracle.

using RDS to build Aurora from an Oracle DB https://aws.amazon.com/tutorials/break-free-from-legacy-databases/migrate-oracle-to-amazon-aurora/

D is my choice. Multi-AZ DB cluster does not support Oracle DB.

Between C&D, D is correct as C is not possible: https://aws.amazon.com/blogs/aws/multi-az-option-for-amazon-rds-oracle/

Not A - Creating multiple instances and keeping them in sync in DMS is surely not "operationally efficient" Not B - "replica in the same zone" -> does not provide "higher availability" Not C - "Multi-AZ cluster" does not support Oracle engine Thus D. Question does not mention that the app would use Oracle-specific features; we're also not asked to minimize application changes. Ideal solution from AWS point of view is to move from Oracle to Aurora.

"Multi-AZ cluster (!)" does not support Oracle. Multi-AZ instance would.

Multi-AZ DB clusters are NOT available with the following engines: RDS for MariaDB RDS for Oracle RDS for SQL Server https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.MultiAZDBClusters.html

It should be C. Oracle DB is supported in RDS Multi-AZ with one standby for HA. https://aws.amazon.com/rds/features/multi-az/. Additionally, a reader instance/replica could be added to RDS Multi-AZ with one standby setup to offload the read requests. Aurora is only supported MySQL and Postgres compatible DB so "D" is out.

requiring high availability and performance.https://aws.amazon.com/rds/aurora/

None options seems valid. Not C because it is not supported. But not D as well. RDS is not Aurora. They are two separate services. Additionally, In multi AZ instance deployment, it only provides fault tolerance, not High avai.

this link expalins why the answer is C and confirms that rds for oracle supports multi-AZ https://aws.amazon.com/blogs/aws/multi-az-option-for-amazon-rds-oracle/

sorry this is the right link: https://aws.amazon.com/ar/blogs/aws/multi-az-option-for-amazon-rds-oracle/

Multi-AZ Cluster does not support Oracle as engine: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.MultiAZDBClusters.html

Unfortunately ALL ANSWERS ARE NOT CORRECT. A. Use AWS Database Migration Service (AWS DMS) to create an Amazon RDS DB instance in multiple AWS Regions. How can I create RDS using DMS ? B. Single-Zone is not suitable for high available solution. C. RDS cluster deployment are not available for DBs: RDS for Db2, RDS for MariaDB, RDS for Oracle, RDS for SQL Server https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.MultiAZDBClusters.html D. Use Amazon RDS deployed in a Multi-AZ instance deployment to create an Amazon Aurora database. Aurora DOES NOT support Oracle DB. Only MySQL and PostgreSQL

The correct answer is: RDS Oracle Multi-AZ instance + Read Replica. But that option isn't listed in the answers. Conclusion: the question is either incomplete or written by idiots.

as pentium75 had pointed out, the stem does not mention that the app would use Oracle-specific features; we're also not asked to minimize application changes. Ideal solution from AWS point of view is to move from Oracle to Aurora.

but Aurora doesnt support oracle db though

In the MOST operationally efficient way, D is better, and A is too much. HOWEVER, Aurora is not Oracle, so this would require migrating from Oracle to Aurora (potentially requiring significant changes to the application, schema, and queries). The question did not say anything about not wanting to migrate. B - 100% wrong. Single-AZ deployment does not meet the higher availability requirement. C - 100% wrong. There's no way to create an Oracle db using RDS.

It is C. Aurora database doesn't support Oracle.

It is D

i am sure just look here https://aws.amazon.com/ar/blogs/aws/amazon-rds-multi-az-db-cluster/

https://aws.amazon.com/rds/features/multi-az/ gives:Amazon RDS Multi-AZ is available for RDS for PostgreSQL, RDS for MySQL, RDS for MariaDB, RDS for SQL Server, RDS for Oracle, and RDS for Db2. Amazon RDS Multi-AZ with two readable standbys is available for RDS for PostgreSQL and RDS for MySQL. So no reader instance.