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 questionsA 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.)
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 …
