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

Questions 6–10

1. 6foundation · easy

   Which tool can be used to validate a database model during a build?

   • ASQL Server Management Studio
   • BPowerShell
   • CMSBuild
   • DAzure Portal
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is an SDK-style SQL Database Project?

   • AA project that requires a graphical designer
   • BA project that is deployed using Azure Data Studio
   • CA project that only contains stored procedures
   • DA project that uses a .NET SDK to build the database
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   Your team uses SQL Database Projects and wants to ensure that every database object has a designated owner who is responsible for its quality and maintenance. You need to implement code ownership in the repository. What should you do?

   • AAdd a CODEOWNERS file to the repository that maps folders or files to specific users or teams.
   • BCreate a separate branch for each owner and require them to merge their own changes.
   • CUse a naming convention that includes the owner's name in the file name.
   • DRequire all pull requests to be approved by the project manager.
   Reveal Solution Discussion Select an answer first
5. 9expert · hard

   Your team uses SQL Database Projects in Azure DevOps. You need to implement deployment pipeline controls that require a change to be approved by both a developer and a DBA before it can be deployed to production. The approval should be required only for production deployments, not for test deployments. What should you do?

   • AAdd a manual approval gate to the test stage and reuse it for production.
   • BAdd two manual approval gates to the production stage, one for the developer and one for the DBA.
   • CUse a service connection that requires two administrators to approve the connection.
   • DAdd a branch policy that requires two reviewers for pull requests to the main branch.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which scenario is best suited for an integration test in a SQL Database Project?

   • AVerifying that a function returns the correct output for a given input
   • BEnsuring that the project builds without errors
   • CChecking that all table definitions match the project model
   • DValidating that a stored procedure correctly reads from and writes to an external API
   Reveal Solution Discussion Select an answer first