Question 420
An earlier incident involved this issue: A globally used database has an RTO of fifteen minutes but its restore copies can only be downloaded over a constrained WAN link. Which continuing safeguard would address the risk?
Explanation
Correct Answer
Measure network and storage restore bottlenecks in DR planning. It targets the actual operating weakness: Recovery architecture was built without measuring data transfer and restore throughput. The immediate repair was: Preposition suitable supported recovery copies or use an appropriate replica strategy with tested bandwidth.
Incorrect Answers
This would review schema permissions when new tables, views, or database roles are introduced. It is useful when an application reaches Cloud SQL but receives permission denied for one schema after a team reorganizes SQL roles, but it does not prevent the issue here: recovery architecture was built without measuring data transfer and restore throughput.
This control would document legal-hold preservation separately from standard backup schedules; it responds to the risk in which an e-commerce database has backups stored for 30 days while a legal hold requires preserving selected records longer. It would not address the current root cause: recovery architecture was built without measuring data transfer and restore throughput.
This would require recovery owner approval before shortening backup availability. It is useful when a Cloud SQL operator sets a short backup retention because storage costs rise, then discovers it violates ransomware recovery requirements, but it does not prevent the issue here: recovery architecture was built without measuring data transfer and restore throughput.