DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ42

VerifiedSecure, optimize, and deploy database solutions

You have an SDK-style SQL database project stored in a Git repository. The project targets an Azure SQL database.

The CI build fails with unresolved reference errors when the project references system objects.

You need to update the SQL database project so that dotnet build validates successfully by including the correct system objects in the database model for Azure SQL Database.

Solution: Add an artifact reference to the Azure SQL Database master.dacpac file.

Does this satisfy the goal?

Explanation

An artifact reference to the Azure SQL Database master.dacpac adds the Azure SQL system-object definitions to the project’s database model. SQL projects support artifact references for master.dacpac in SDK-style projects, allowing build-time validation of references to system objects. SQL projects system objects — Microsoft Learn

Learn more

Community Discussion

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