A team is building a CI/CD pipeline for a SQL Database Project. They have limited time in the pipeline and need to balance fast feedback with confidence. They want to run unit tests on every commit and integration tests only on pull requests to the main branch. Which testing strategy should they implement?

Run both unit and integration tests on every commit to any branch.

Run only integration tests on every commit and skip unit tests.

Run unit tests only on PRs to main and integration tests only on release branches.

Run unit tests in the CI build for every branch, and run integration tests in a separate pipeline triggered only for PRs to main.

Which tool is commonly used to create and run unit tests for SQL Database Projects in Visual Studio?

SQL Server Management Studio (SSMS)

In SQL Database Projects, what is the typical scope of a unit test?

Testing the deployment pipeline for errors

Testing the entire database schema for consistency

Testing a single database object in isolation

Testing the interaction between multiple stored procedures

Which security principle should be applied when designing authentication tables?

Store passwords in plain text for simplicity

Use the same password for all users

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 3

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

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 1–5

1expert · hard
A team is building a CI/CD pipeline for a SQL Database Project. They have limited time in the pipeline and need to balance fast feedback with confidence. They want to run unit tests on every commit and integration tests only on pull requests to the main branch. Which testing strategy should they implement?
Select an answer first
2foundation · easy
Which tool is commonly used to create and run unit tests for SQL Database Projects in Visual Studio?
Select an answer first
3foundation · easy
In SQL Database Projects, what is the typical scope of a unit test?
Select an answer first
4foundation · easy
Which Azure service is commonly used for secrets management in CI/CD pipelines?
Select an answer first
5foundation · easy
Which security principle should be applied when designing authentication tables?
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.

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

Questions 1–5

Which tool is commonly used to create and run unit tests for SQL Database Projects in Visual Studio?

In SQL Database Projects, what is the typical scope of a unit test?

Which Azure service is commonly used for secrets management in CI/CD pipelines?

Which security principle should be applied when designing authentication tables?

Keep studying — Secure, optimize, and deploy database solutions