Question 60
An application team must address both issues before release. A team runs a schema release while long-running migrations are still active from the previous deployment. A team wants to deploy the same tested SQL package to staging and production but rebuilds it separately with different dependencies. Which response best addresses these needs?
Explanation
Correct Answer
First, parallel DDL changes can conflict and leave a database in an indeterminate release state. Second, promoting one artifact reduces untracked differences between tested and released database code.
Incorrect Answers
Bind the production artifact to the reviewed commit or release tag and verify provenance at deployment; Promote the same immutable build artifact through validated environments and use environment-specific secure configuration: parallel DDL changes can conflict and leave a database in an indeterminate release state.
Add safe concurrency controls and deployment-state checks to avoid overlapping schema changes.
Add safe concurrency controls and deployment-state checks to avoid overlapping schema changes; add the specified environment approval gate before the deployment step and retain its audit record: promoting one artifact reduces untracked differences between tested and released database code.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests