Your team uses SQL Database Projects and wants to validate that the database model adheres to naming conventions and does not contain disallowed data types. The validation must run automatically in the CI pipeline. What should you do?

Add a custom build task that runs a PowerShell script to scan the .sql files for naming violations.

Create a unit test that checks the model's XML representation.

Use SQL Server Data Tools (SSDT) static analysis rules in the project and run them during the build.

Use schema drift detection to compare the model to a reference database.

A company wants to ensure that no schema changes are deployed to production unless they have passed integration tests against a test database. They use SQL Database Projects and Azure Pipelines. Which pipeline design should they use?

Create a pipeline that deploys to production first and then runs integration tests.

Create a single pipeline that builds the project, runs integration tests, and then deploys to production.

Create a pipeline that only runs integration tests and does not deploy.

Create a multi-stage pipeline with build, test, and production deployment stages, and require the test stage to succeed before production.

What is an approval trigger in a deployment pipeline?

A manual approval step before deployment

Your team uses SQL Database Projects in Azure DevOps. You need to implement deployment pipeline controls so that changes are not deployed to production without approval from the database administrator. What should you do?

Use a branch policy that requires a pull request for changes to the main branch.

Set the production deployment stage to run automatically on every commit.

Use a service connection with limited permissions for the production deployment.

Add a manual approval gate to the production deployment stage in the pipeline.

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 3

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

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 31–35

31application · medium
Your team uses SQL Database Projects and wants to validate that the database model adheres to naming conventions and does not contain disallowed data types. The validation must run automatically in the CI pipeline. What should you do?
Select an answer first
32application · medium
A company wants to ensure that no schema changes are deployed to production unless they have passed integration tests against a test database. They use SQL Database Projects and Azure Pipelines. Which pipeline design should they use?
Select an answer first
33foundation · easy
Which file format is used to define the database model in a SQL Database Project?
Select an answer first
34foundation · easy
What is an approval trigger in a deployment pipeline?
Select an answer first
35application · medium
Your team uses SQL Database Projects in Azure DevOps. You need to implement deployment pipeline controls so that changes are not deployed to production without approval from the database administrator. 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.