Question 90
The following database problem was corrected: A Cloud SQL service promises recovery to within five minutes, but backups are only taken nightly. Which result demonstrates that the root cause was addressed?
Explanation
Correct Answer
An isolated restore recovers data to a qualifying point within the stated RPO. The observed state validates the proposed fix: Configure a supported PITR-capable recovery design and test a timestamp-based restore. It addresses this cause: The stated recovery point objective is unsupported by the implemented backup and log-retention strategy.
Incorrect Answers
Even if this observation were recorded, it would support a case where an incident response team learns that Cloud SQL automated backups were retained for fewer days than an audit investigation requires. It would not verify that an isolated restore recovers data to a qualifying point within the stated RPO.
This finding relates to a situation in which a new firewall rule blocks application TCP sessions to a private SQL instance although ICMP tests appear healthy. The current remediation must instead show that an isolated restore recovers data to a qualifying point within the stated RPO.
Even if this observation were recorded, it would support a case where a trading application loses service during an unannounced maintenance period despite an available supported maintenance scheduling option. It would not verify that an isolated restore recovers data to a qualifying point within the stated RPO.