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

Questions 21–25

1. 21foundation · easy

   In a SQL Database Project, how is reference data typically stored in source control?

   • AAs binary files in a separate repository
   • BAs environment variables in the pipeline
   • CAs INSERT statements in a post-deployment script
   • DAs JSON files that are imported at runtime
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the purpose of assigning code ownership in SQL Database Projects?

   • ATo automatically deploy code
   • BTo ensure accountability for code changes
   • CTo encrypt the database
   • DTo improve query performance
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A team uses SQL Database Projects and has a main branch and a release branch. A developer accidentally merged a schema change into the release branch that should have gone to main first. They need to revert the change without losing the work. What should they do?

   • AUse git reset --hard to remove the commit from the release branch.
   • BUse git revert to create a new commit that undoes the change on the release branch.
   • CDelete the release branch and recreate it from main.
   • DManually edit the schema files to remove the change and commit.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   You are designing authentication for a deployment pipeline that uses SQL Database Projects. The pipeline needs to authenticate to Azure SQL Database using a managed identity. You need to ensure that the pipeline can connect without storing credentials. What should you do?

   • AUse Azure AD authentication with a user account and store the password in a variable group.
   • BEnable a system-assigned managed identity on the pipeline agent and grant it access to the database.
   • CCreate a SQL login and store the password in Azure Key Vault.
   • DUse a service principal with a client secret and store the secret in the pipeline.
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   Your CI/CD pipeline for SQL Database Projects needs to connect to a target database using a SQL login. You must ensure that the password is not stored in the repository or visible in pipeline logs. What should you do?

   • AUse a service principal with a client secret stored in the pipeline.
   • BUse a variable group linked to an Azure Key Vault and reference the secret in the pipeline.
   • CStore the password as a plain text variable in the pipeline definition.
   • DHardcode the password in the deployment script.
   Reveal Solution Discussion Select an answer first