Discuss Microsoft DP-800 Exam Topic 2 Question 12

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 ieferences system objects.

You need to update the SQL database project to ensure 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.Mastet NuGet package to the project.

Does this meet the goal?

AYes

BNo

Suggested Answer: B

The package named Microsoft.SqlServer.Dacpacs.Master is the generic master system DACPAC package, but the question requires the correct system objects for Azure SQL Database. Microsoft's system-objects documentation distinguishes platform-specific system references, and for Azure SQL Database the correct package is the Azure-specific master DACPAC, not the generic master package.

So adding Microsoft.SqlServer.Dacpacs.Master does not meet the goal for an Azure SQL Database-targeted SDK-style project. The expected package is the Azure-specific one.

Get Premium DP-800 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

21 comments · newest first

Cathern 14 days ago

True, testing is key before finalizing the solution.

Justine 19 days ago

But we need to test it first to be sure.

Shawnta 24 days ago

I agree, it seems like the right approach.

Helaine 29 days ago

I feel confident about this solution. It targets Azure specifically.

Halina 1 month ago

I'm not so sure. What if there are other dependencies?

Portia 1 month ago

Yes, it should include the necessary system objects.

Shawnna 1 month ago

But does it really solve the unresolved reference errors?

Jonell 2 months ago

I think adding the NuGet package is a good idea.

Leoma 2 months ago

I agree with B. There might be other dependencies we need to consider.

Dorthy 2 months ago

A is definitely the way to go. The package is designed for this purpose.

Kristeen 2 months ago

I feel like it should be B. Adding a package might not resolve the reference errors.

Denny 2 months ago

I think the answer is A. It makes sense to include the necessary package.

Rosamond 3 months ago

Adding that package sounds like a solid plan!

Diane 3 months ago

Wait, is that the right version for Azure?

Amira 3 months ago

Totally agree, this should fix the unresolved references.

Lazaro 3 months ago

I thought we needed a different package for Azure SQL?

Jonelle 3 months ago

That package is essential for system objects!

Whitney 3 months ago

I believe the answer is B) No, because I think we need to ensure the project references the correct system objects directly rather than relying solely on a NuGet package.

Sharen 4 months ago

I feel like we talked about the importance of the right dependencies, but I can't quite remember if this specific package is necessary for Azure SQL.

Flo 4 months ago

I think we practiced a similar question where we had to include system objects, and I recall that just adding a package might not resolve all reference issues.

Ulysses 4 months ago

I remember discussing how system objects need to be referenced correctly, but I'm not sure if adding that NuGet package is the right approach.

Microsoft DP-800 Exam - Topic 2 Question 12 Discussion