In a SQL Database Project, what is the primary purpose of integration tests?

To check the syntax of all T-SQL scripts in the project without executing them

To verify that individual functions and stored procedures return correct results in isolation

To validate that the database objects work correctly with external systems and dependencies

To measure the performance of queries under heavy load

What is the recommended way to store connection strings in a SQL Database Project?

In a plain text file in the repository

In a secrets management service

Your team is adopting SQL Database Projects and needs to configure source control to manage the project files. You want to ensure that only approved changes are merged and that every change is attributable to a developer. What should you do?

Allow developers to push directly to the main branch and use commit messages for tracking.

Create a branch for each developer and merge changes without review.

Configure the repository to require pull requests with at least one reviewer before merging.

Use a shared network folder to store the project files and track changes manually.

What is the purpose of updating a SQL Database Project?

To incorporate changes to the database schema

To change the database server location

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 3

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

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 11–15

11foundation · easy
In a SQL Database Project, what is the primary purpose of integration tests?
Select an answer first
12foundation · easy
What is the recommended way to store connection strings in a SQL Database Project?
Select an answer first
13application · easy
Your team is adopting SQL Database Projects and needs to configure source control to manage the project files. You want to ensure that only approved changes are merged and that every change is attributable to a developer. What should you do?
Select an answer first
14foundation · easy
Which branching strategy is commonly used to isolate feature development in SQL Database Projects?
Select an answer first
15foundation · easy
What is the purpose of updating a SQL Database Project?
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.