Microsoft Certified:SQL AI Developer Associate
Domain 2Objective 3
Implement CI/CD by Using SQL Database Projects DP-800 Practice Questions (Page 8)
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 36–40
- 36
A company has a SQL Database Project and uses Azure Pipelines. They want to enforce that only the database administrator can approve deployments to production, and that the build must pass before any deployment. They also want to ensure that the production deployment uses the exact artifact from the build. What should they configure?
Select an answer first - 37
How are changes from a SQL Database Project deployed to a target database?
Select an answer first - 38
How does code ownership contribute to code quality?
Select an answer first - 39
What is the purpose of a pull request in a SQL Database Project workflow?
Select an answer first - 40
Which tool is used to detect schema drift in SQL Database Projects?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.