Question 410
Engineers believe they have resolved this failure: An application owner requests recovery of one table, but operations plan to overwrite the entire production database. Which follow-up evidence is most convincing?
Explanation
Correct Answer
The missing table is recovered without discarding unaffected production changes. The result directly checks whether the remedy worked: Restore into an isolated environment and extract only the required table or rows through an approved process. The cause was the chosen restore method ignores isolation and the scope of the requested recovery.
Incorrect Answers
This finding relates to a situation in which read replica utilization remains modest but users see stale dashboards after daily imports. The current remediation must instead show that the missing table is recovered without discarding unaffected production changes.
This finding relates to a situation in which a company runs full database exports every hour and production query latency degrades during each export. The current remediation must instead show that the missing table is recovered without discarding unaffected production changes.
This finding relates to a situation in which a Cloud SQL backup job succeeds but a restore test fails because the target project's permissions and prerequisites are missing. The current remediation must instead show that the missing table is recovered without discarding unaffected production changes.