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.)
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.
More questions
Other DBS-C01 practice questions
- Question 1A company has a hybrid environment in which a VPC connects to an on-premises network thro…
- Question 2A Database Specialist migrated an existing production MySQL database from on-premises to …
- Question 3A media company is using Amazon RDS for PostgreSQL to store user dat a. The RDS DB instan…
- Question 4A Database Specialist is working with a company to launch a new website built on Amazon A…
- Question 5A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon R…
- Question 6A financial services company is developing a shared data service that supports different …
