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…

Choose your answer, then check it against the explanation.

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
Question 22 of 35

Keep practicing

Take the free DBS-C01 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test

More questions

Other DBS-C01 practice questions

Scroll to Top