Question 190
A database team wants evidence that it fixed this issue: A company needs short-lived database login credentials but continues distributing shared static SQL users to every microservice. Which result would verify success?
Explanation
Correct Answer
A distinct authorized workload signs in using its identity while a revoked identity is rejected. The result directly checks whether the remedy worked: Evaluate supported Cloud SQL IAM database authentication and assign least-privilege database roles. The cause was the authentication architecture does not associate database access with individual workload identity.
Incorrect Answers
That result would matter when a Cloud SQL public-IP deployment permits connections from a wide internet CIDR merely to support one fixed corporate egress. It does not establish that a distinct authorized workload signs in using its identity while a revoked identity is rejected, which is the evidence needed here.
The result would be meaningful for a problem where a high-throughput PostgreSQL-compatible analytics-heavy transactional application needs a managed service optimized for demanding reads. For this question, closure depends on confirming that a distinct authorized workload signs in using its identity while a revoked identity is rejected.
This finding belongs with a situation in which a batch worker intermittently cannot access a private database after a networking reconfiguration, while other workers succeed. The required acceptance finding here is that a distinct authorized workload signs in using its identity while a revoked identity is rejected.