Q446. A company has deployed a database in Amazon RDS for MySQL. Due to increased transactions, the database s

Question

Q446. 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.)

Accepted Answer

C. Allow long-running transactions to complete on the source DB instance.

Accepted Answer

E. Enable automatic backups on the source instance by setting the backup retention period to a value other than 0.

Answer

A. Enable binlog replication on the RDS primary node.

Answer

B. Choose a failover priority for the source DB instance.

Answer

D. Create a global table and specify the AWS Regions where the table will be available.

Q16 — AWS SAA-C03 Ch.7

Correct Answer: C. Allow long-running transactions to complete on the source DB instance., E. Enable automatic backups on the source instance by setting the backup retention period to a value other than 0.