Question 870
The original database complaint was: A deployment service account holds broad project edit privileges because it needs to create one managed database instance. Which observed result best verifies the repair?
Explanation
Correct Answer
The pipeline creates permitted resources and cannot alter unrelated assets. The result directly checks whether the remedy worked: Assign purpose-limited supported provisioning roles and separate runtime access identities. The cause was provisioning identity was granted general administration instead of scoped infrastructure permissions.
Incorrect Answers
The result would be meaningful for a problem where a company claims two read replicas provide automatic HA for its Cloud SQL primary without enabling the approved failover configuration. For this question, closure depends on confirming that the pipeline creates permitted resources and cannot alter unrelated assets.
That result would matter when an automated database schema deployment runs before a new application release but introduces an incompatible column change. It does not establish that the pipeline creates permitted resources and cannot alter unrelated assets, which is the evidence needed here.
That result would matter when a new database instance goes live before an accountable team is assigned its alerts, backups and upgrade decisions. It does not establish that the pipeline creates permitted resources and cannot alter unrelated assets, which is the evidence needed here.