Question 460
The service owner asks how to avoid a repeat of: A Cloud SQL production instance uses maximum-size machine resources all week because one monthly maintenance task is costly. Which operational check is the best match?
Explanation
Correct Answer
Size for workload classes rather than occasional maintenance peaks alone. The recurring risk is short-duration maintenance demand drives constant overprovisioning of ordinary application capacity. This check makes that risk visible before another incident.
Incorrect Answers
The proposed check would include network direction and geography in cloud database cost models, helping with cases where a business compares only database node hourly prices while transferring large report exports to another continent. The recurring exposure described here is that short-duration maintenance demand drives constant overprovisioning of ordinary application capacity.
This would document freshness contracts for cached and precomputed data. It is useful when a relational workload repeats the same expensive aggregation for every dashboard refresh, but it does not prevent the issue here: short-duration maintenance demand drives constant overprovisioning of ordinary application capacity.
The proposed check would recertify partner database permissions after contract and scope changes, helping with cases where a third-party billing application is granted broad project owner privileges merely to run an hourly read-only database report. The recurring exposure described here is that short-duration maintenance demand drives constant overprovisioning of ordinary application capacity.