AWS Certified Database – Specialty — Question 40

A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.
The Database Specialist wrote and ran a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.
How should the Database Specialist edit the script to fix this issue?

Answer options

• A. Stop the source instances before stopping their read replicas
• B. Delete each read replica before stopping its corresponding source instance
• C. Stop the read replicas before stopping their source instances
• D. Use the AWS CLI to stop each read replica and source instance at the same time

Correct answer: B

Explanation

The correct answer is B because read replicas cannot be stopped while their source instance is still running; they must be deleted first. Options A and C suggest stopping instances in a sequence that won't resolve the issue, while D proposes simultaneous stopping, which is not supported by RDS for read replicas.