Question 100
The service owner asks how to avoid a repeat of: A trading application loses service during an unannounced maintenance period despite an available supported maintenance scheduling option. Which operational check is the best match?
Explanation
Correct Answer
Include database maintenance events in the application availability calendar. The original failure arose from: Maintenance scheduling and application change windows were not coordinated. The control reduces that failure mode.
Incorrect Answers
The failure in the question arises because maintenance scheduling and application change windows were not coordinated. A safeguard to inventory engine dependencies before committing to a managed database replacement serves situations where a mission-critical Oracle workload requires unsupported kernel extensions and administrators propose moving it unchanged to Cloud SQL rather than this one.
This control would test regional disaster scenarios independently from within-region failover; it responds to the risk in which a company assumes its regional Cloud SQL HA standby protects it against total loss of the region. It would not address the current root cause: maintenance scheduling and application change windows were not coordinated.
The failure in the question arises because maintenance scheduling and application change windows were not coordinated. A safeguard to monitor cross-cluster replication freshness against recovery objectives serves situations where a Bigtable team claims replication ensures data protection but never measures how late changes reach the alternate cluster rather than this one.