A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an
8XL-sized instance, and the read replicas are each XL-sized instances.
Users report that database queries are returning stale data. The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary.
Which changes will reduce the lag? (Choose two.)

A. Deploy two additional read replicas matching the existing replica DB instance size.

B. Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.

C. Move the read replicas to the same Availability Zone as the primary DB instance.

D. Increase the instance size of the primary DB instance within the same instance class.

E. Increase the instance size of the read replicas to the same size and class as the primary DB instance.






 

Suggested Answer: BC

Community Answer: BE




This question is in DBS-C01 AWS Certified Database – Specialty Exam
For getting AWS Certified Database – Specialty Certificate


Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Amazon.
Trademarks, certification & product names are used for reference only and belong to Amazon.
The website does not contain actual questions and answers from Amazon's Certification Exam.