SOA-C02 Question 65
Select 3You are managing a MySQL database on Amazon RDS in the us-east-1 region. To improve read scalability and disaster recovery, you decide to configure read replicas. Additionally, your team requires one replica in the us-west-2 region for failover purposes. Which of the following actions will meet the requirements?
- A
Enable automatic backups on the primary database instance to allow creating replicas.
- B
Create an Amazon RDS read replica in the us-east-1 region to handle read scalability.
- C
Enable cross-region replication by creating a read replica in the us-west-2 region for disaster recovery.
- D
Configure the read replicas in both regions as multi-AZ deployments for additional resilience.
- E
Promote the read replica in the us-west-2 region to a standalone database immediately after creation.
Show answer and explanation
Correct answers: A, B, C
Explanation
To meet the requirements, you need to ensure backups are enabled on the primary instance to allow creating replicas. A read replica in the same region improves read scalability, while a cross-region read replica provides disaster recovery capabilities. Read replicas cannot be multi-AZ, and promoting a replica immediately after creation is not necessary unless a failover event occurs.
- A. Correct.
This is correct because automatic backups must be enabled on the primary database instance to create read replicas. Without backups, replication cannot be established.
- B. Correct.
This is correct because creating a read replica in the same region (us-east-1) allows for read scalability by offloading read operations from the primary database.
- C. Correct.
This is correct because creating a cross-region read replica (in us-west-2) ensures disaster recovery capabilities. This replica can be promoted to a standalone database in case of failure in the primary region.
- D. Incorrect.
This is incorrect because read replicas do not support multi-AZ deployments. Multi-AZ configurations are only applicable to primary database instances, not replicas.
- E. Incorrect.
This is incorrect because promoting the read replica in us-west-2 immediately after creation would make it a standalone database, breaking replication and defeating the purpose of disaster recovery.