DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ41

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 the Microsoft.SqlServer.Dacpacs.Azure.Master NuGet package to the project.

Does this achieve the goal?

Explanation

The Microsoft.SqlServer.Dacpacs.Azure.Master package provides the Azure SQL Database master system-database DACPAC. Adding it as a package reference supplies system-object definitions to an SDK-style SQL project, resolving build validation errors caused by unresolved system-object references.

Learn more

Community Discussion

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