Question 30
The original database complaint was: An AlloyDB application suffers repeated buffer cache misses after a product catalog doubles in size. Which observed result best verifies the repair?
Explanation
Correct Answer
Cache miss and disk-read pressure decline with stable query latency. The observed state validates the proposed fix: Measure memory and query working-set needs, then right-size compute and query access patterns. It addresses this cause: The working set and join workload exceed the memory provisioned for the production instance.
Incorrect Answers
The result would be meaningful for a problem where a Cloud SQL application performs large analytical joins that stall small OLTP transactions on the same database. For this question, closure depends on confirming that cache miss and disk-read pressure decline with stable query latency.
The result would be meaningful for a problem where a regulated database backup policy requires recovery copies outside a primary failure boundary, but all copies remain colocated. For this question, closure depends on confirming that cache miss and disk-read pressure decline with stable query latency.
This finding relates to a situation in which a Cloud SQL database runs out of free storage during a large index build even though the indexed table itself fits. The current remediation must instead show that cache miss and disk-read pressure decline with stable query latency.