Question 860
A database team wants to prevent a recurrence of this issue: A Terraform rollout attempts to recreate a production Cloud SQL instance because a mutable resource label was used as its identity. Which preventive practice is most relevant?
Explanation
Correct Answer
Enforce database deletion protection and plan review in IaC pipelines. This is preventive rather than a one-time repair; it addresses the underlying failure: Infrastructure state and resource identity were not reconciled before deployment.
Incorrect Answers
This control would review database alerts against service dependency and failure-mode inventories; it responds to the risk in which a newly provisioned Cloud SQL fleet has CPU alarms but no alerts for storage exhaustion or replica delay. It would not address the current root cause: infrastructure state and resource identity were not reconciled before deployment.
The failure in the question arises because infrastructure state and resource identity were not reconciled before deployment. A safeguard to run negative write-on-replica tests after routing changes serves situations where a team creates two Cloud SQL read replicas but an internal load balancer sends INSERT statements to a replica rather than this one.
The failure in the question arises because infrastructure state and resource identity were not reconciled before deployment. A safeguard to require accountable ownership and tested runbooks before production cutover serves situations where a new database instance goes live before an accountable team is assigned its alerts, backups and upgrade decisions rather than this one.