DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ43

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.Master NuGet package to the project.

Does this satisfy the goal?

Explanation

For an SDK-style SQL project targeting Azure SQL Database, system-object validation requires a reference to the Azure SQL Database master model, provided by the Microsoft.SqlServer.Dacpacs.Azure.Master package. Microsoft.SqlServer.Dacpacs.Master is the SQL Server master package and is not the correct target-platform system-object reference.

Learn more

Community Discussion

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