AWS Certified Solutions Architect – Associate (SAA-C03) — Question 216

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

The correct actions are to allow long-running transactions to finish on the source DB instance (C) and enable automatic backups (E). This is important because long-running transactions should be completed to ensure data consistency before creating a read replica, and automatic backups must be enabled to facilitate the replication process. The other options, while relevant in other contexts, do not directly relate to the prerequisites for implementing a read replica.