A company has deployed a database in Amazon RDS for MySQL. Due to increased transactions, the database support team reports slow reads and recommends adding a read replica. Which combination of actions should a solutions architect take before implementing this change? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Allow long-running transactions to complete on the source DB instance., Enable automatic backups on the source instance by setting the backup retention period to a value other than 0..
Why this is the answer
Before creating an Amazon RDS for MySQL read replica, you must enable automatic backups on the source instance by setting the backup retention period to a value other than 0. This is a prerequisite for read replica creation in RDS. Additionally, allowing long-running transactions to complete on the source DB instance is crucial. If a read replica is created while long-running transactions are active, it can lead to replication lag and potential data inconsistencies when the replica starts synchronizing. Choosing a failover priority for the source DB instance is related to Multi-AZ deployments, not a prerequisite for read replica creation. Creating a global table is for DynamoDB, not RDS for MySQL. Binlog replication is automatically handled by RDS when creating a read replica; manual enabling is not required.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed