Question 160
A postincident review documents: A support team posts a Cloud SQL connection string containing a database password in a public issue tracker. Which ongoing check targets the underlying failure?
Explanation
Correct Answer
Apply secret detection and redaction to database troubleshooting artifacts. The original failure arose from: The incident workflow reveals a long-lived secret outside its approved trust boundary. The control reduces that failure mode.
Incorrect Answers
This would review total stored footprint rather than only table payload size. It is useful when an IoT company budgets for only primary data but storage charges climb because of indexes, replicas, and retained backups, but it does not prevent the issue here: the incident workflow reveals a long-lived secret outside its approved trust boundary.
This control would document cross-project resource policies and verify service accounts after project moves; it responds to the risk in which a cross-project Cloud Run workload can reach a database network but receives IAM permission errors during connection. It would not address the current root cause: the incident workflow reveals a long-lived secret outside its approved trust boundary.
This would test private database reachability for each application runtime type. It is useful when a private database can be contacted from a VM but the same request fails from a serverless runtime in another network, but it does not prevent the issue here: the incident workflow reveals a long-lived secret outside its approved trust boundary.