Question 450
The following database problem was corrected: A Cloud SQL team adds a separate read replica for every service without measuring common read load. Which result demonstrates that the root cause was addressed?
Explanation
Correct Answer
Read SLA is maintained with fewer redundant replica resources. The result directly checks whether the remedy worked: Consolidate compatible read workloads onto appropriately sized replicas and measure contention. The cause was replica proliferation increases storage and maintenance cost without a demonstrated performance benefit.
Incorrect Answers
Even if this observation were recorded, it would support a case where a transactional workload uses a read replica for all reads, including read-after-write order confirmation, and customers see stale states. It would not verify that read SLA is maintained with fewer redundant replica resources.
Even if this observation were recorded, it would support a case where an application owner requests recovery of one table, but operations plan to overwrite the entire production database. It would not verify that read SLA is maintained with fewer redundant replica resources.
This finding belongs with a situation in which an AlloyDB workload experiences high read cost because repeated full-table scans retrieve far more columns than necessary. The required acceptance finding here is that read SLA is maintained with fewer redundant replica resources.