DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ26

Secure, optimize, and deploy database solutions

You have a database named DB1. Its schema is stored in a Git repository as an SDK-style SQL database project.

You have a GitHub Actions workflow that already runs dotnet build and generates a database artifact.

You need to add a deployment step that publishes the .dacpac file to an Azure SQL database by using secrets stored in GitHub repository secrets.

What should you include in the workflow?

Explanation

The Azure SQL Deploy GitHub Action publishes a DACPAC when configured with azure/sql-action@v2, action: publish, the DACPAC path, and a connection-string sourced from a GitHub secret. extract performs the reverse operation, creating a DACPAC from an existing database.

Learn more

Community Discussion

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