DBS-C01 practice question 22 of 35

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…

Full set: 322 questions
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 dat a. 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.)
Answer options
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.
Scroll to Top