Microsoft · DP-800
Drift, secrets, and pipelines
DP-800 · Lesson 14 of 20 · 1:40:54
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: schema drift and SqlPackage defaults, schema comparison and extract, Script and DeployReport, secrets, OpenID Connect, and Key Vault, and pipeline controls with branch policies, CODEOWNERS, environments, and branch control checks. Includes three original practice questions.
Preview the topics
- Last week, someone created an index directly in production to fix a slow report. The fix is right, and tonight’s pipeline will publish the project. What should the team do first?
- The GitHub workflow that publishes to Azure SQL Database must not store any password or client secret. What should it use?
- A developer edited the pipeline on a feature branch so that it deploys to production. Which control makes the production service connection refuse that run?