Which testing approach is best suited to validate that a stored procedure correctly processes data from a linked server?

Schema comparison between the project and the linked server

Static analysis of the stored procedure code

Integration test that connects to the linked server

Unit test that mocks the linked server

What is a key characteristic of integration tests for SQL Database Projects?

They do not require any external dependencies

They are faster than unit tests

They only test the database schema

They run against a real database instance

A developer wants to create a new SQL Database Project for an existing Azure SQL Database. They want to use the SDK-style project format and ensure the model is validated before committing. Which tool should they use?

Use Azure Data Studio's schema compare feature to generate a project.

Use the sqlpackage.exe command-line tool to extract the schema into a .dacpac file.

Use the Microsoft.Build.Sql SDK project type and run dotnet build to validate the model.

Use the SQL Database Projects extension in VS Code to create a legacy .sqlproj file.

What is the purpose of validating a database model in a SQL Database Project?

To ensure the model meets project requirements and standards

To generate the deployment script

What is schema drift in the context of SQL Database Projects?

When the database is moved to a new server

When the database performance degrades

When the database schema deviates from the project model

Microsoft Certified:SQL AI Developer Associate

Domain 2Objective 3

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

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 46–50

46foundation · easy
Which testing approach is best suited to validate that a stored procedure correctly processes data from a linked server?
Select an answer first
47foundation · easy
What is a key characteristic of integration tests for SQL Database Projects?
Select an answer first
48application · medium
A developer wants to create a new SQL Database Project for an existing Azure SQL Database. They want to use the SDK-style project format and ensure the model is validated before committing. Which tool should they use?
Select an answer first
49foundation · easy
What is the purpose of validating a database model in a SQL Database Project?
Select an answer first
50foundation · easy
What is schema drift in the context of SQL Database Projects?
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.