DBS-C01 · Question #8
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
The correct answer is B. Delete each read replica before stopping its corresponding source instance. Explanation Amazon RDS does not allow you to stop a DB instance that has active read replicas - the stop operation will simply fail, which is exactly what the Database Specialist observed in the logs. Option B is correct because deleting the read replicas first removes this depen
Question
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 executed 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?
Options
- AStop the source instances before stopping their read replicas
- BDelete each read replica before stopping its corresponding source instance
- CStop the read replicas before stopping their source instances
- DUse the AWS CLI to stop each read replica and source instance at the same
How the community answered
(37 responses)- A8% (3)
- B84% (31)
- C3% (1)
- D5% (2)
Explanation
Explanation
Amazon RDS does not allow you to stop a DB instance that has active read replicas - the stop operation will simply fail, which is exactly what the Database Specialist observed in the logs. Option B is correct because deleting the read replicas first removes this dependency, allowing the source instance to then be stopped successfully; since the company is closing temporarily, the read replicas can be recreated when operations resume.
Option A is wrong because attempting to stop the source instance before its read replicas violates the RDS dependency rule - RDS will block the stop action as long as read replicas exist. Option C is wrong because while stopping replicas first sounds logical, RDS read replicas cannot be independently stopped - they can only be deleted or left running. Option D is wrong for the same reason; no AWS CLI command can stop a read replica as a standalone action, and running stop commands simultaneously does not bypass the dependency constraint.
Memory Tip: Think of read replicas as "children" that must leave the house (be deleted) before the parent (source instance) can lock the doors and stop. You can't stop a parent RDS instance while its read replica children are still around!
Topics
Community Discussion
No community discussion yet for this question.