Question 400 An API still reads an old column during rollout of a replacement column. Which technical choice addresses this need? Generate and inspect a deployment plan before executing destructive changes Detect schema drift by comparing target objects with the project model Use a backward-compatible expand-and-contract migration Deploy the same validated build artifact through environments Explanation Correct Answer C:This implementation permits old and new application versions to coexist temporarily. Incorrect Answers A:This option reviews possible drops and data-loss operations. This does not meet the need for a method that permits old and new application versions to coexist temporarily. B:This option identifies out-of-band changes before applying a release. This does not meet the need for a method that permits old and new application versions to coexist temporarily. D:This alternative reduces drift between tested and production schemas. This does not meet the need for a method that permits old and new application versions to coexist temporarily.
Question 401 An administrator added a production index manually and the next publish plans to change it. What should the engineer choose? Detect schema drift by comparing target objects with the project model Deploy the same validated build artifact through environments Use a backward-compatible expand-and-contract migration Generate and inspect a deployment plan before executing destructive changes Explanation Correct Answer A:Detect schema drift by comparing target objects with the project model is the appropriate choice: it identifies out-of-band changes before applying a release. The deployment should be tested with representative data. Incorrect Answers B:This option reduces drift between tested and production schemas. This does not meet the need for a method that identifies out-of-band changes before applying a release. C:This choice permits old and new application versions to coexist temporarily. This does not meet the need for a method that identifies out-of-band changes before applying a release. D:This option reviews possible drops and data-loss operations. This does not meet the need for a method that identifies out-of-band changes before applying a release.
Question 402 A GitHub-hosted pipeline must authenticate to Azure without checking in a client secret. Which solution best satisfies the stated constraint? Store deployment credentials in an approved secret manager Protect the main branch with required pull-request reviews Use federated identity or managed deployment credentials where supported Require code-owner approval for sensitive database paths Explanation Correct Answer C:This approach avoids long-lived shared service passwords. Incorrect Answers A:This alternative prevents publishing connection strings in source code. This does not meet the need for a method that avoids long-lived shared service passwords. B:That technique prevents unapproved direct schema changes. This does not meet the need for a method that avoids long-lived shared service passwords. D:That technique assigns review responsibility to designated maintainers. This does not meet the need for a method that avoids long-lived shared service passwords.
Question 403 Changes to the security-schema folder must be approved by database security owners. What should the engineer choose? Use federated identity or managed deployment credentials where supported Require code-owner approval for sensitive database paths Protect the main branch with required pull-request reviews Gate production deployment on approved environment reviews Explanation Correct Answer B:This approach assigns review responsibility to designated maintainers. Incorrect Answers A:This option avoids long-lived shared service passwords. This does not meet the need for a method that assigns review responsibility to designated maintainers. C:This option prevents unapproved direct schema changes. This does not meet the need for a method that assigns review responsibility to designated maintainers. D:This alternative separates build success from authorization to release. This does not meet the need for a method that assigns review responsibility to designated maintainers.
Question 404 A pull request modifies a view dependency and should fail before touching staging. What should the SQL developer implement? Keep reference data changes in reviewed source control migrations Use an SDK-style SQL project with pinned tooling when supported Build the SQL Database Project in CI before deploying Represent the intended schema as declarative SQL Database Project files Explanation Correct Answer C:This implementation catches model syntax and dependency errors early. Incorrect Answers A:That technique makes configuration/reference records traceable. This does not meet the need for a method that catches model syntax and dependency errors early. B:This alternative improves reproducible project builds across machines. This does not meet the need for a method that catches model syntax and dependency errors early. D:This choice enables repeatable build and model validation from source. This does not meet the need for a method that catches model syntax and dependency errors early.
Question 405 A production publish may change tables holding regulated records. What is the most appropriate design decision? Detect schema drift by comparing target objects with the project model Use a backward-compatible expand-and-contract migration Record a rollback and restore plan before database changes Deploy the same validated build artifact through environments Explanation Correct Answer C:Record a rollback and restore plan before database changes fits because it supports recovery from a failed production schema migration. That addresses the stated technical constraint. Incorrect Answers A:This option identifies out-of-band changes before applying a release. This does not meet the need for a method that supports recovery from a failed production schema migration. B:That technique permits old and new application versions to coexist temporarily. This does not meet the need for a method that supports recovery from a failed production schema migration. D:That technique reduces drift between tested and production schemas. This does not meet the need for a method that supports recovery from a failed production schema migration.
Question 406 A CI build passes but production schema changes require a named approver. Which implementation is the best fit? Use feature branches and merge-conflict resolution before integration Gate production deployment on approved environment reviews Use federated identity or managed deployment credentials where supported Protect the main branch with required pull-request reviews Explanation Correct Answer B:Gate production deployment on approved environment reviews fits because it separates build success from authorization to release. That addresses the stated technical constraint. Incorrect Answers A:This option keeps parallel work coordinated without overwriting teammates' changes. This does not meet the need for a method that separates build success from authorization to release. C:This alternative avoids long-lived shared service passwords. This does not meet the need for a method that separates build success from authorization to release. D:This option prevents unapproved direct schema changes. This does not meet the need for a method that separates build success from authorization to release.
Question 407 A stored procedure must interact correctly with actual foreign keys and views. What should the SQL developer implement? Create automated database unit tests for deterministic routines Build the SQL Database Project in CI before deploying Use integration tests against a disposable deployment database Keep reference data changes in reviewed source control migrations Explanation Correct Answer C:This choice checks interactions and dependencies across deployed objects. Incorrect Answers A:This choice verifies small units of SQL behavior in isolation. This does not meet the need for a method that checks interactions and dependencies across deployed objects. B:That technique catches model syntax and dependency errors early. This does not meet the need for a method that checks interactions and dependencies across deployed objects. D:This option makes configuration/reference records traceable. This does not meet the need for a method that checks interactions and dependencies across deployed objects.
Question 408 An engineer wants to push a destructive DDL change directly to the protected branch. Which approach would you recommend? Store deployment credentials in an approved secret manager Protect the main branch with required pull-request reviews Use feature branches and merge-conflict resolution before integration Use federated identity or managed deployment credentials where supported Explanation Correct Answer B:Protect the main branch with required pull-request reviews is the appropriate choice: it prevents unapproved direct schema changes. The deployment should be tested with representative data. Incorrect Answers A:This choice prevents publishing connection strings in source code. This does not meet the need for a method that prevents unapproved direct schema changes. C:This option keeps parallel work coordinated without overwriting teammates' changes. This does not meet the need for a method that prevents unapproved direct schema changes. D:This option avoids long-lived shared service passwords. This does not meet the need for a method that prevents unapproved direct schema changes.
Question 409 A build agent and developer workstation produce inconsistent outputs from different tooling. Which solution best satisfies the stated constraint? Build the SQL Database Project in CI before deploying Create automated database unit tests for deterministic routines Use an SDK-style SQL project with pinned tooling when supported Represent the intended schema as declarative SQL Database Project files Explanation Correct Answer C:This implementation fits because it improves reproducible project builds across machines. That addresses the stated technical constraint. Incorrect Answers A:This choice catches model syntax and dependency errors early. This does not meet the need for a method that improves reproducible project builds across machines. B:That technique verifies small units of SQL behavior in isolation. This does not meet the need for a method that improves reproducible project builds across machines. D:This option enables repeatable build and model validation from source. This does not meet the need for a method that improves reproducible project builds across machines.
Question 410 Two teams alter the same stored procedure in separate pull requests. What is the most appropriate next design step? Store deployment credentials in an approved secret manager Use feature branches and merge-conflict resolution before integration Gate production deployment on approved environment reviews Require code-owner approval for sensitive database paths Explanation Correct Answer B:This implementation fits because it keeps parallel work coordinated without overwriting teammates' changes. That addresses the stated technical constraint. Incorrect Answers A:This alternative prevents publishing connection strings in source code. This does not meet the need for a method that keeps parallel work coordinated without overwriting teammates' changes. C:This choice separates build success from authorization to release. This does not meet the need for a method that keeps parallel work coordinated without overwriting teammates' changes. D:That technique assigns review responsibility to designated maintainers. This does not meet the need for a method that keeps parallel work coordinated without overwriting teammates' changes.