DP-800: Developing AI-Enabled Database Solutions

Question

You have a database named db1. Its schema is stored in a Git repository as an SDK-style SQL database project. The repository includes the following GitHub Actions workflow.

Question Image

For each statement below, select Yes when it is true; otherwise, select No.

Yes or No

Statements	Yes	No
Unit tests run automatically whenever changes are pushed to main.
Schema validation occurs during the Build step.
Schema validation occurs during the Deploy step.

Explanation

A push to main sets github.ref to refs/heads/main, so the unit-tests job runs after its required build-and-deploy job. Building an SDK-style SQL database project validates object relationships and target-platform T-SQL syntax, then produces a DACPAC. SqlPackage Publish performs deployment verification by default before publishing and stops if it finds issues that could block deployment.

Learn more

DP-800: Developing AI-Enabled Database Solutions

AstroTutor

Notes

Readiness

QuestionQ46

Community Discussion