Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-800 Exam - Topic 3 Question 3 Discussion

You have a GitHub Actions workflow that builds and deploys an Azure SQL database. The schema is stored in a GitHub repository as an SDK-style SQL database project.Following a code review, you discover that you need to generate a report that shows whether the production schema has diverged from the model in source control.Which action should you add to the pipeline?
A) SqlPackage.exe /Action:DriftReport
B) SqlPackage.exe /Action:DeployReport
C) SqlPackage.exe /Action:Extract
D) SqlPackage.exe /Action:Script

Microsoft DP-800 Exam - Topic 3 Question 3 Discussion

Actual exam question for Microsoft's DP-800 exam
Question #: 3
Topic #: 3
[All DP-800 Questions]

You have a GitHub Actions workflow that builds and deploys an Azure SQL database. The schema is stored in a GitHub repository as an SDK-style SQL database project.

Following a code review, you discover that you need to generate a report that shows whether the production schema has diverged from the model in source control.

Which action should you add to the pipeline?

Show Suggested Answer Hide Answer
Suggested Answer: A

Microsoft documents that DriftReport creates an XML report showing changes that have been made to the registered database since it was last registered. That is the action intended to detect whether the production schema has diverged from the expected model baseline in your deployment workflow.

This is different from DeployReport, which shows the changes that would be made by a publish action. In other words:

DriftReport answers: Has the deployed database drifted from the registered state/model?

DeployReport answers: What changes would be applied if I published now?

The other options are not the right fit:

Extract creates a DACPAC from an existing database, not a drift analysis report.

Script generates a deployment script, not a schema-drift report.

So to generate a report that shows whether production has diverged from the model in source control, add:

SqlPackage.exe /Action:DriftReport


Contribute your Thoughts:

0/2000 characters
Gabriele
28 days ago
I disagree, B) DeployReport seems more relevant.
upvoted 0 times
...
Helene
1 month ago
A) SqlPackage.exe /Action:DriftReport is the right choice!
upvoted 0 times
...
Von
2 months ago
I could be wrong, but I think Extract is more about pulling the schema from the database rather than comparing it.
upvoted 0 times
...
Broderick
2 months ago
I practiced a similar question where we had to check for schema differences, and I feel like DriftReport was the right choice there too.
upvoted 0 times
...
Harris
2 months ago
I'm not entirely sure, but I remember something about DeployReport being used for deployment comparisons. Is that relevant here?
upvoted 0 times
...
Micaela
2 months ago
I think we might need to use the DriftReport action since we're looking for differences between the production schema and the source control model.
upvoted 0 times
...

Save Cancel