A team manages a Fabric database project in Git. They have a main branch and feature branches. A developer accidentally merged a breaking schema change to main. The team wants to revert the change and also ensure that the same mistake cannot be merged again. What should they do?

Use Fabric's built-in version history to restore the previous version of the database.

Delete the main branch and recreate it from the feature branch.

Manually edit the database project files to undo the change and commit directly to main.

Revert the merge commit and add a CI check that runs schema validation on pull requests.

When configuring a deployment pipeline in Fabric, what is the purpose of setting up rules for a data source?

To override the connection string when deploying to a different stage

To schedule automatic refreshes

To limit who can access the pipeline

A team uses a Git repository for their Fabric workspace. They want to maintain a stable main branch and use a separate branch for release candidates. Which branching strategy should they use?

Git Flow with a develop branch and release branches.

GitHub Flow with only a main branch and feature branches.

Trunk-based development with short-lived branches and no release branches.

Your organization uses Fabric deployment pipelines to promote content from Development to Test and then to Production. After a recent promotion, the Production pipeline failed because a linked service referenced a workspace-specific connection string that did not exist in Production. What should you configure to prevent this class of error in future deployments?

Manually edit the connection string in Production after each deployment.

Remove the linked service from the pipeline and recreate it manually in each stage.

Use deployment rules to override the connection string for the Production stage.

Store the connection string in a Fabric notebook and reference it from the pipeline.

Your organization has separate Fabric workspaces for Development, Test, and Production. You need to promote a set of reports and datasets from Development to Test, but you want to exclude a specific dataset that is not ready. What should you do?

Move the dataset to a different workspace and then deploy.

Use the deployment pipeline and select only the items you want to deploy.

Delete the dataset from the Development workspace before deploying.

Deploy everything and then delete the dataset from Test.

Microsoft Certified:Fabric Data Engineer Associate

Domain 1Objective 2

Implement Lifecycle Management in Fabric DP-700 Practice Questions (Page 5)

Part of the Implement and manage an analytics solution domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 3–6 from this objective — we provide 39 practice questions to prepare you well beyond it. (estimate)

39questions here

8free pages

7concepts

30–35%of the exam

Questions 21–25

21expert · hard
A team manages a Fabric database project in Git. They have a main branch and feature branches. A developer accidentally merged a breaking schema change to main. The team wants to revert the change and also ensure that the same mistake cannot be merged again. What should they do?
Select an answer first
22foundation · easy
When configuring a deployment pipeline in Fabric, what is the purpose of setting up rules for a data source?
Select an answer first
23application · medium
A team uses a Git repository for their Fabric workspace. They want to maintain a stable main branch and use a separate branch for release candidates. Which branching strategy should they use?
Select an answer first
24application · medium
Your organization uses Fabric deployment pipelines to promote content from Development to Test and then to Production. After a recent promotion, the Production pipeline failed because a linked service referenced a workspace-specific connection string that did not exist in Production. What should you configure to prevent this class of error in future deployments?
Select an answer first
25application · medium
Your organization has separate Fabric workspaces for Development, Test, and Production. You need to promote a set of reports and datasets from Development to Test, but you want to exclude a specific dataset that is not ready. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-700

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-700” is a trademark of its owner, used for identification only.