SOA-C02 Question 67
Select 4Your company uses an Amazon RDS for MySQL database in a production environment and has recently experienced latency issues during peak traffic hours. To improve read performance, you have decided to implement replicas. Which of the following are true about implementing Amazon RDS Read Replicas or Amazon Aurora Replicas in this scenario?
- A
Amazon RDS Read Replicas can be created in the same or different AWS Region as the primary database.
- B
Amazon Aurora Replicas share the same underlying storage as the primary instance, providing lower replication lag compared to Amazon RDS Read Replicas.
- C
Read Replicas for Amazon RDS can be used for both read and write operations.
- D
You must enable automatic backups on the primary RDS database before creating a Read Replica.
- E
Amazon Aurora automatically promotes one of its replicas to primary in case of a failure without requiring manual intervention.
Show answer and explanation
Correct answers: A, B, D, E
Explanation
In this scenario, implementing Amazon RDS Read Replicas or Amazon Aurora Replicas can improve read performance and ensure high availability. RDS Read Replicas can be created across Regions and require automatic backups to be enabled on the primary instance. Aurora Replicas provide near real-time replication due to shared storage and offer automatic failover capabilities, making them a robust option for high availability.
- A. Correct.
Correct: Amazon RDS Read Replicas can be created within the same AWS Region or across different Regions to improve read performance and provide disaster recovery options.
- B. Correct.
Correct: Amazon Aurora Replicas benefit from shared distributed storage, which enables near real-time replication and lower replication lag compared to RDS Read Replicas.
- C. Incorrect.
Incorrect: Read Replicas are designed for read operations only and cannot be used for write operations. Write operations must go to the primary database.
- D. Correct.
Correct: Automatic backups must be enabled on the primary database to create a Read Replica, as the backups are used to initialize the replica.
- E. Correct.
Correct: Amazon Aurora supports automatic failover, where one of the Aurora Replicas is promoted to the primary instance in case of a failure, ensuring high availability.