Question 400
A SQL migration now passes a retention test and has data-owner approval. Which remaining risk is most important to address before treating the AI-generated change as fully validated?
Explanation
Correct Answer
Approval and CI only assess what reviewers and tests actually cover. Unlisted dependencies, archived-event requirements or mismatched production schemas can still make a migration unsafe.
Incorrect Answers
Approval does not create a rollback guarantee; dropping a column may destroy data and recovery can require a separate backup and restore plan.
A passing test applies to the reviewed migration and contract. Future changes still need risk analysis, review and adequate coverage.
Automated migration and schema checks can be used for AI-assisted SQL just as for other SQL. The limitation is coverage, not a technical impossibility.