DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ71

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: Build the project by running dotnet build -bl -flp:v=diag.

Does this meet the goal?

Explanation

The unresolved reference errors occur because the SDK-style database project is missing the correct system-object references (such as the Azure SQL Database master/system dacpac or the correct DatabaseSchemaProvider/target platform setting) needed for dotnet build to resolve system objects for an Azure SQL Database target. Simply re-running dotnet build with binary logging and diagnostic-level file logging flags changes only how build diagnostics are captured; it does not add any system-object references or change the project's schema provider, so the build will still fail with the same unresolved references.

Community Discussion

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