Question 480
After an incident where a scheduled Cloud SQL export job repeatedly creates files but no operator notices that the export objects contain zero rows, which recurring control would best prevent the same defect?
Explanation
Correct Answer
Validate scheduled export content rather than only exit status. The original failure arose from: Job success metrics track process completion instead of expected business data content. The control reduces that failure mode.
Incorrect Answers
For the situation in which a new database query takes seconds instead of milliseconds after a table passes several million rows, it makes sense to review execution plans for high-volume filters after data growth. Here, job success metrics track process completion instead of expected business data content, so the safeguard misses the recurring fault.
This control would gate database provisioning on repeatable security and connectivity validation; it responds to the risk in which an infrastructure-as-code change deploys a Cloud SQL instance with public access even though the approved template requires private connectivity. It would not address the current root cause: job success metrics track process completion instead of expected business data content.
The proposed check would check scheduled operations whenever organization policy constraints change, helping with cases where an automatic backup schedule begins failing because a newly enforced organization policy denies its target storage location. The recurring exposure described here is that job success metrics track process completion instead of expected business data content.