DBS-C01 · Question #209
DBS-C01 Question #209: Real Exam Question with Answer & Explanation
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #209. The question stem and answer options stay visible for context.
Question
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.)
Options
- ADeploy two additional read replicas matching the existing replica DB instance size.
- BMigrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora
- CMove the read replicas to the same Availability Zone as the primary DB instance.
- DIncrease the instance size of the primary DB instance within the same instance class.
- EIncrease the instance size of the read replicas to the same size and class as the primary DB
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.