Your team uses SQL Database Projects in Azure DevOps. You need to implement a branching strategy that supports parallel development of features and ensures that changes are reviewed before reaching the main branch. What should you do?

Use a release branch and merge all changes to it without review.

Use a single branch and have developers commit directly to it.

Create a feature branch for each task and merge to main via pull requests.

Use a trunk-based development model with short-lived branches and direct merges.

A team uses SQL Database Projects to deploy to Azure SQL Database. They suspect that the production database has drifted from the project schema due to manual changes. They want to identify the differences before the next deployment. What should they do?

Deploy the project to production and see if it fails.

Use the SQL Database Projects SDK to generate a script that drops all objects.

Run a schema compare between the project and the production database using Azure Data Studio.

Run a data compare between the project and the production database.

What is the purpose of a branching policy in a deployment pipeline?

To monitor database performance

To automatically deploy to production

To enforce code review before merging

Your organization uses SQL Database Projects to manage a database that integrates with an external ERP system. You need to verify that the latest project changes work correctly with the ERP's expected schema and data formats. The test must run automatically in the CI pipeline. What should you do?

Run a static analysis tool on the project to check for compatibility issues.

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

Create an integration test that deploys the project to a test environment and runs scripts that simulate ERP calls.

Use schema drift detection to compare the project to the ERP's database.

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 3

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

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 41–45

41application · medium
Your team uses SQL Database Projects in Azure DevOps. You need to implement a branching strategy that supports parallel development of features and ensures that changes are reviewed before reaching the main branch. What should you do?
Select an answer first
42application · medium
A team uses SQL Database Projects to deploy to Azure SQL Database. They suspect that the production database has drifted from the project schema due to manual changes. They want to identify the differences before the next deployment. What should they do?
Select an answer first
43foundation · easy
Which source control system is commonly used with SQL Database Projects?
Select an answer first
44foundation · easy
What is the purpose of a branching policy in a deployment pipeline?
Select an answer first
45application · medium
Your organization uses SQL Database Projects to manage a database that integrates with an external ERP system. You need to verify that the latest project changes work correctly with the ERP's expected schema and data formats. The test must run automatically in the CI pipeline. What should you 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.