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

Questions 51–52

1. 51application · medium

   Your team uses SQL Database Projects in Azure DevOps to manage a legacy database. You need to add a unit test that validates a stored procedure's logic without requiring a live database connection. The test must run in the pipeline and fail the build if the logic is incorrect. What should you do?

   • AWrite a unit test using a testing framework that mocks the database context and calls the stored procedure's logic directly.
   • BCreate a SQL Server Data Tools (SSDT) unit test that uses a connection string to a test database in the pipeline.
   • CUse the SQL Database Projects SDK-style model to compile the stored procedure and assert on the generated T-SQL output.
   • DAdd a tSQLt test project and configure the pipeline to run it against a local SQL Server instance.
   Reveal Solution Discussion Select an answer first
2. 52expert · hard

   Your team is developing a SQL Database Project with complex stored procedures and integrations with external services. You need to design a testing strategy that catches logic errors early and verifies that the database works with the external services. The strategy must run in CI and not require a live database for the fast tests. What should you do?

   • ARun only unit tests that mock the database context and skip integration tests.
   • BRun only integration tests that deploy to a test database and call the external services.
   • CRun unit tests that mock the database context and integration tests that use a test database in separate pipeline stages.
   • DRun integration tests first, then unit tests if integration tests pass.
   Reveal Solution Discussion Select an answer first