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

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

C. Use Amazon RDS deployed in a Multi-AZ cluster deployment to create an Oracle database. Direct 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.

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

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.

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/

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

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.

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

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.

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 is C. Aurora database doesn't support Oracle.

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.

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

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

Option C is correct one . As there is no option for 'Aurora(Oracle Compatible)'.so this kick out D from race.

Using RDS Multi-AZ provides high availability and failover capabilities for the primary Oracle database. The reader instance in the Multi-AZ cluster can be used for offloading reporting workloads from the primary instance. This improves performance. RDS Multi-AZ has automatic failover between AZs. DMS and Aurora migrations (A, D) would incur more effort and downtime. Single-AZ with a read replica (B) does not provide the AZ failover capability that Multi-AZ does.