AWS Certified Solutions Architect – Associate (SAA-C02) — Question 520

A company has deployed a database in Amazon RDS for MySQL. Due to increased transactions, the database support team is reporting slow reads against the
DB instance and recommends adding a read replica.
Which combination of actions should a solutions architect take before implementing this change? (Choose two.)

Answer options

• A. Enable binlog replication on the RDS primary node.
• B. Choose a failover priority for the source DB instance.
• C. Allow long-running transactions to complete on the source DB instance.
• D. Create a global table and specify the AWS Regions where the table will be available.
• E. Enable automatic backups on the source instance by setting the backup retention period to a value other than 0.

Correct answer: C, E

Explanation

To create a read replica in Amazon RDS for MySQL, automatic backups must be enabled on the source DB instance by setting the backup retention period to a non-zero value. Additionally, it is critical to let any long-running transactions on the source instance finish before creating the replica to prevent performance issues or replication lag. Other options like global tables are for DynamoDB, and binlog replication is handled automatically once backups are enabled.