AWS Certified Database – Specialty — Question 47

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?

Answer options

• A. New volumes created from snapshots load lazily in the background
• B. Long-running statements on the master
• C. Insufficient resources on the master
• D. Overload of a single replication thread by excessive writes on the master

Correct answer: A

Explanation

The correct answer is A because newly created read replicas initially load data in the background, leading to potential slow performance until the data is fully loaded. Options B and C do not directly relate to the replica's performance, as they concern the master instance, and option D, while it could impact the master, does not explain the slow response time of the read replica itself.