A team uses SQL Database Projects and has a CODEOWNERS file that assigns ownership of the stored procedures folder to a senior developer. However, the senior developer is on vacation, and a pull request modifying a stored procedure is blocked because the owner is required to approve. What should they do to unblock the PR while maintaining accountability?

Remove the CODEOWNERS file and rely on general reviewers.

Override the branch policy and merge the PR without review.

Wait until the senior developer returns to approve the PR.

Temporarily add another developer as a co-owner in the CODEOWNERS file and have them review.

A team uses SQL Database Projects and wants to ensure that every file in the project has a designated owner who is responsible for reviewing changes. What should they implement?

Use a CODEOWNERS file in the repository to assign owners to specific paths.

Require that all developers review all changes.

Use a naming convention that includes the owner's name in the file name.

Use a manual process where the project lead assigns reviewers for each PR.

Your team uses SQL Database Projects to manage a database. You suspect that the production database has been modified outside of the project (schema drift). You need to identify the differences between the project and the production database. What should you do?

Use the schema comparison tool in Azure Data Studio to compare the project to the production database.

Deploy the project to production and see if it fails.

Query the production database's system tables to compare to the project files manually.

Run a unit test that validates the project's build output.

A company is adopting SQL Database Projects and wants to configure source control to support multiple developers working on the same database schema. They want to avoid direct commits to the main branch and ensure code reviews. Which source control configuration should they use?

Use a shared network folder to store the project files.

Use a central repository with a single main branch and allow all developers to commit directly.

Use a Git repository with feature branches and pull requests that require reviewers.

Use a database project in Azure DevOps with TFVC and check-out locking.

A team uses SQL Database Projects and has a production database that has drifted from the project. They want to bring the database back in sync with the project without losing any data. They also want to prevent future drift. What should they do?

Use schema compare to generate a deployment script that updates the database to match the project, then deploy it.

Update the project to match the production database.

Drop the production database and redeploy from the project.

Use a data-only deployment to update the database.

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 3

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

Part of the Secure, optimize, and deploy database solutions domain, which accounts for 35–40% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~18–32 in this domain), expect 5–8 from this objective — we provide 52 practice questions to prepare you well beyond it. (estimate)

52questions here

11free pages

14concepts

35–40%of the exam

Questions 16–20

16expert · hard
A team uses SQL Database Projects and has a CODEOWNERS file that assigns ownership of the stored procedures folder to a senior developer. However, the senior developer is on vacation, and a pull request modifying a stored procedure is blocked because the owner is required to approve. What should they do to unblock the PR while maintaining accountability?
Select an answer first
17application · medium
A team uses SQL Database Projects and wants to ensure that every file in the project has a designated owner who is responsible for reviewing changes. What should they implement?
Select an answer first
18application · medium
Your team uses SQL Database Projects to manage a database. You suspect that the production database has been modified outside of the project (schema drift). You need to identify the differences between the project and the production database. What should you do?
Select an answer first
19application · medium
A company is adopting SQL Database Projects and wants to configure source control to support multiple developers working on the same database schema. They want to avoid direct commits to the main branch and ensure code reviews. Which source control configuration should they use?
Select an answer first
20expert · hard
A team uses SQL Database Projects and has a production database that has drifted from the project. They want to bring the database back in sync with the project without losing any data. They also want to prevent future drift. What should they do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-800

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.