Implement CI/CD by Using SQL Database Projects DP-800 Practice Questions (Page 6)

Questions 26–30

1. 26application · medium

   A team uses SQL Database Projects and wants to enforce that every pull request includes a successful build and passes unit tests before merging. They also want to ensure that the database model adheres to naming conventions. Which pipeline control should they implement?

   • ASchedule a nightly build that runs the build and tests.
   • BRequire a manual approval step in the release pipeline for every PR.
   • CAdd a build validation pipeline that runs dotnet build and unit tests, and set it as a branch policy.
   • DUse a pre-commit hook to run the build and tests locally.
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   What is the main advantage of keeping reference data in source control?

   • AIt allows the data to be versioned and audited
   • BIt speeds up query performance
   • CIt automatically updates all environments
   • DIt eliminates the need for database backups
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A team has a SQL Database Project that is deployed to a test environment. They want to automate the deployment to a production environment after successful testing, but they need to ensure that the production deployment is approved by a manager. What should they configure?

   • AAdd a pre-deployment approval gate in the release pipeline for the production stage.
   • BSet the production deployment to run automatically on every commit to main.
   • CUse a manual deployment step that requires a user to click a button.
   • DUse a scheduled deployment that runs nightly.
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   Your team uses SQL Database Projects and needs to deploy a new version of the database to a test environment. You want to ensure that the deployment only applies the changes that are in the project and does not overwrite unrelated changes that may exist in the test environment. What should you do?

   • AUse the schema comparison tool to generate a deployment script that only includes the differences between the project and the test database.
   • BUse the SQL Package tool with the /p:IgnoreAnsiNulls=true option.
   • CUse the SQL Package (SqlPackage) tool with the Publish action and the /p:BlockOnPossibleDataLoss=true option.
   • DUse the SQL Package tool with the /p:DropObjectsNotInSource=true option.
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   What is the primary benefit of configuring source control for SQL Database Projects?

   • AIt automatically deploys to production
   • BIt provides version history and collaboration
   • CIt encrypts the database
   • DIt improves query performance
   Reveal Solution Discussion Select an answer first