Question 740
A main SQL project references common schema definitions but builds differ across developer machines. The team proposes this approach: Pin compatible project dependencies and run clean builds on isolated agents. Which technical principle supports this approach?
Explanation
Correct Answer
Stable project references and pinned build dependencies improve reproducibility. Reproducible builds do not prove schema migrations are safe on live data.
Incorrect Answers
That explanation assumes the wrong technical cause: Pin versioned dependencies and validate clean-agent builds to establish reproducibility.
The proposed mechanism is not sufficient because Reproducible builds require stable resolved references and artifact comparisons, not only successful compilation.
This inference does not follow from the SQL or service behavior: Pin SDK and package versions in configuration and reproduce on isolated build agents. The stated assumption would still allow the documented defect to occur, so it cannot explain why the proposed fix works.