Question 280
A team chooses a generative coding model for SQL schema migrations solely by fluency of its prose. Initial testing shows: Selected prompts produce reviewable migrations that pass controlled CI validation. Which limitation should the team still consider?
Explanation
Correct Answer
A successful sample does not guarantee all generated migrations are safe. AI-generated schema changes require deterministic tests and human code review independent of text quality. Evaluate candidates on SQL compilation, tests and regression handling.
Incorrect Answers
Model fluency is not a test of executable SQL; target-engine compile and integration checks are necessary.
Generated migrations need semantic diff review, schema invariants and data tests beyond syntax validation.
Evaluation must measure SQL correctness, security constraints, failure paths and regressions under controlled tests.