Question 210
The following database problem was corrected: A deployment pipeline uses a project-wide editor role simply to read database instance status during health checks. Which result demonstrates that the root cause was addressed?
Explanation
Correct Answer
Monitoring works and modification attempts using that identity are denied. This distinguishes actual recovery from a merely healthy-looking console. The targeted correction was: Replace the broad role with purpose-limited supported read permissions for the pipeline identity.
Incorrect Answers
Even if this observation were recorded, it would support a case where a client connects through an encrypted endpoint but disables hostname checking to work around a certificate mismatch. It would not verify that monitoring works and modification attempts using that identity are denied.
That result would matter when a Spanner application returns permission denied only when run under its deployment service account. It does not establish that monitoring works and modification attempts using that identity are denied, which is the evidence needed here.
Even if this observation were recorded, it would support a case where a Firestore document tracking a single global counter begins returning contention failures during a popular livestream. It would not verify that monitoring works and modification attempts using that identity are denied.