DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ44

VerifiedSecure, optimize, and deploy database solutions

You have a GitHub Actions workflow that builds and deploys an Azure SQL database. The schema is kept in a GitHub repository as an SDK-style SQL database project.

After a code review, you determine that you must generate a report showing whether the production schema has diverged from the model in source control.

Which action should you add to the pipeline?

Explanation

DeployReport generates an XML report of the changes that a publish operation would make. Using the DACPAC built from the source-controlled SQL project as the source and the production Azure SQL database as the target reveals schema differences without deploying them. DriftReport instead reports changes to a registered database since its last registration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!