Skip to content

DP-700 · Domain 1: Implement and manage an analytics solution · 33% of the exam

Task 1.2: Implement lifecycle management in Fabric

Version control with Git integration, database projects for SQL database in Fabric, and deployment pipelines with stages, rules and variable libraries.

Study it

  • Git integration, branch workspaces and conflicts

    Lesson coming

  • SQL database projects and source control

    Lesson coming

  • Deployment pipelines, deployment rules and variable libraries

    Lesson coming

Sample questions

Try each one before opening the answer. Every option is explained, with the Microsoft documentation page that proves it.

Question 1 · choose 1

A data engineer holds the Member role in a Fabric workspace and Contribute permission on an Azure DevOps repo. When she opens Workspace settings > Git integration, she can't connect the workspace to the repo. What has to happen?

  1. AShe's granted Create branch permission on the Azure DevOps repo
  2. BA workspace Admin makes the connection; after that, she can commit and update
  3. CShe's given the Contributor role in the workspace instead of Member
  4. DShe creates a personal access token and saves it in the workspace settings for everyone
Show the answer and why
  • AShe's granted Create branch permission on the Azure DevOps repo

    Incorrect

    Connecting needs only Read on the repo; the block here is her workspace role.

  • BA workspace Admin makes the connection; after that, she can commit and update

    Correct

    Connecting a workspace to a Git repo is limited to workspace Admins; Members and Contributors work in it once it's connected.

  • CShe's given the Contributor role in the workspace instead of Member

    Incorrect

    Contributor grants less than Member; connecting a workspace to Git needs the Admin role.

  • DShe creates a personal access token and saves it in the workspace settings for everyone

    Incorrect

    Git connections are per user, and a token doesn't change who may connect the workspace.

Only a workspace Admin can connect, sync or disconnect a workspace and a Git repo. Once it's connected, Members and Contributors with write permission on the items can commit and update, limited by their own Git permissions. Each user who works in the workspace configures their own Git account connection.

Question 2 · choose 1

A workspace with 30 items is connected to a branch that holds an older copy of the same items. Fabric asks which direction to sync. The team wants the items as they are in the workspace today, and the old branch content can be replaced. What should you choose?

  1. AUpdate the workspace from the branch
  2. BCommit the workspace's current items to the branch
  3. CSwitch the workspace to a new empty branch, then update the workspace items
  4. DDisconnect, delete the branch folder, then update the workspace from Git
Show the answer and why
  • AUpdate the workspace from the branch

    Incorrect

    Updating overwrites the workspace with the old branch content, which is the opposite of the goal.

  • BCommit the workspace's current items to the branch

    Correct

    Committing exports all supported workspace content to Git and overwrites what's in the branch.

  • CSwitch the workspace to a new empty branch, then update the workspace items

    Incorrect

    Updating from an empty branch has nothing to bring in; it doesn't save the workspace items either.

  • DDisconnect, delete the branch folder, then update the workspace from Git

    Incorrect

    Updating from an emptied folder copies nothing, and the workspace items still aren't committed.

When both the workspace and the branch have content at connection time, you must pick the sync direction. Committing exports the workspace and overwrites the branch; updating overwrites the workspace, which Fabric asks you to confirm because a branch can be restored to an earlier commit but a workspace can't.

Question 3 · choose 1

Omar is a Contributor in the team workspace, which is connected to the main branch of an Azure DevOps repo where he has Read, Contribute and Create branch permissions. A branch policy on main requires pull requests, so his commits from Fabric fail. He must get his notebook changes reviewed and merged without being made a workspace Admin. What should he do?

  1. ABranch out to a new workspace and feature branch, then open a pull request
  2. BSwitch the team workspace to a new feature branch and commit there
  3. CUpdate the workspace from Git first, then retry the same commit straight to main
  4. DDisconnect the workspace and reconnect it to a feature branch
Show the answer and why
  • ABranch out to a new workspace and feature branch, then open a pull request

    Correct

    Branch out is open to Contributors with Create branch permission; the PR then goes through main's policy.

  • BSwitch the team workspace to a new feature branch and commit there

    Incorrect

    Switching the connected branch is restricted to workspace Admins by default.

  • CUpdate the workspace from Git first, then retry the same commit straight to main

    Incorrect

    Updating doesn't change the branch policy; direct commits to main stay blocked.

  • DDisconnect the workspace and reconnect it to a feature branch

    Incorrect

    Disconnecting and reconnecting a workspace is an Admin-only operation.

Committing from Fabric needs Contribute permission and a branch policy that allows direct commits. Branching out creates a new branch from the connected one and connects a new or existing workspace to it; Admins, Members and Contributors can do it with Read and Create branch permissions in the repo. Changes then return to main through the provider's pull request process.

Question 4 · choose 1

A workspace you want to connect to GitHub holds pipelines, notebooks and a few items of a type that Fabric Git integration doesn't support. What happens to those unsupported items when the workspace is connected and synced?

  1. AThey're committed as JSON stubs that can't be updated back
  2. BThe connection fails until the unsupported items are removed
  3. CThey're deleted from the workspace on the first update from Git
  4. DThey stay in the workspace and are left out of commits and updates
Show the answer and why
  • AThey're committed as JSON stubs that can't be updated back

    Incorrect

    Nothing is written to Git for unsupported items.

  • BThe connection fails until the unsupported items are removed

    Incorrect

    A workspace with unsupported items can still be connected.

  • CThey're deleted from the workspace on the first update from Git

    Incorrect

    Unsupported items aren't deleted; they're left as they are.

  • DThey stay in the workspace and are left out of commits and updates

    Correct

    Unsupported items are ignored by Git integration; they aren't committed, synced or deleted.

If a workspace or Git folder contains item types that Git integration doesn't support, it can still be connected. The unsupported items are ignored: they aren't saved or synced and they aren't deleted, and they appear in the source control panel without the option to commit or update them.

Question 5 · choose 1

A deployment pipeline promotes notebooks from Test to Production. In Production, every notebook must use LH_Gold as its default lakehouse. LH_Gold lives in a shared data workspace that isn't part of the pipeline, and the notebooks' code must not change between stages. What should you configure?

  1. AA data source rule for each notebook, defined in the Test stage
  2. BA parameter rule for each notebook, defined in the Production stage
  3. CA default lakehouse rule for each notebook, defined in the Production stage
  4. DA %%configure cell in each notebook that names LH_Gold as the default lakehouse
Show the answer and why
  • AA data source rule for each notebook, defined in the Test stage

    Incorrect

    Data source rules don't exist for notebooks, and rules belong to the target stage.

  • BA parameter rule for each notebook, defined in the Production stage

    Incorrect

    Parameter rules apply to semantic models and dataflows Gen1, not notebooks.

  • CA default lakehouse rule for each notebook, defined in the Production stage

    Correct

    Default lakehouse rules apply to notebooks and set the lakehouse they use in the target stage.

  • DA %%configure cell in each notebook that names LH_Gold as the default lakehouse

    Incorrect

    A %%configure cell changes the notebooks' code, which the requirement rules out.

Deployment pipelines support data source, parameter and default lakehouse rules, depending on the item type; notebooks support only the default lakehouse rule. Rules are created in the target stage by the item's owner and take effect on the next deployment into that stage.

Question 6 · choose 1

You commit a PySpark notebook from a Git-connected workspace. What does the repository receive?

  1. AAn .ipynb file with the code cells and their last output
  2. BA binary export of the notebook that only Fabric can read
  3. CA notebook-content.py source file with its cells but no output
  4. DOnly the notebook's metadata, with the code kept in the workspace
Show the answer and why
  • AAn .ipynb file with the code cells and their last output

    Incorrect

    Fabric uses source files instead of a standard .ipynb file.

  • BA binary export of the notebook that only Fabric can read

    Incorrect

    The source format is plain text designed for readable Git diffs.

  • CA notebook-content.py source file with its cells but no output

    Correct

    Fabric stores notebooks as source files, and cell output isn't synced to Git.

  • DOnly the notebook's metadata, with the code kept in the workspace

    Incorrect

    Code and markdown cells are stored in the source file.

When you commit a notebook, Fabric stores it as source files; a PySpark notebook becomes notebook-content.py. The file keeps notebook metadata (such as the default lakehouse and attached environment), markdown cells and code cells, but not cell output.

Question 7 · choose 1

A workspace runs on a capacity in West Europe, and the team's Azure DevOps organization is in East US. Connecting the workspace to the repo fails. What's needed?

  1. AThe team makes the Azure DevOps project public
  2. BThe repo is connected with a service principal instead of a user account
  3. CThe team grants Create branch permission on the repo
  4. DA tenant admin enables cross-geo export for Git integration
Show the answer and why
  • AThe team makes the Azure DevOps project public

    Incorrect

    Project visibility doesn't lift the cross-region restriction.

  • BThe repo is connected with a service principal instead of a user account

    Incorrect

    The identity used for the connection doesn't lift the region restriction.

  • CThe team grants Create branch permission on the repo

    Incorrect

    Connecting needs Read; the region mismatch is the problem.

  • DA tenant admin enables cross-geo export for Git integration

    Correct

    Cross-geo export is required when the workspace and the Azure repo are in different regions.

Git integration must be enabled by an administrator, and when the workspace and an Azure repo are in two different regions, the tenant admin must also enable cross-geo export. The restriction doesn't apply to GitHub.

Question 8 · choose 1

You assign existing Dev and Test workspaces to a new deployment pipeline. Both contain a notebook named NB_Clean, but they weren't paired during assignment. What happens when you deploy NB_Clean from Dev to Test?

  1. AThe Test NB_Clean is overwritten since the names match
  2. BThe deployment fails until the Test notebook is renamed and paired
  3. CTest ends up with a second NB_Clean, paired with Dev's
  4. DThe two notebooks are merged cell by cell
Show the answer and why
  • AThe Test NB_Clean is overwritten since the names match

    Incorrect

    Overwriting happens only for paired items.

  • BThe deployment fails until the Test notebook is renamed and paired

    Incorrect

    The deployment succeeds and creates a new, paired copy.

  • CTest ends up with a second NB_Clean, paired with Dev's

    Correct

    Unpaired items aren't overwritten even with the same name and type; a clean deploy creates a copy.

  • DThe two notebooks are merged cell by cell

    Incorrect

    Deployments copy items; they never merge content.

Pairing associates an item in one stage with the same item in the adjacent stage. If items aren't paired, even with the same name and type, deploying doesn't overwrite the target item: it's a clean deploy that creates a copy in the target stage and pairs it with the source.

Question 9 · choose 1

A user holds the Viewer role in a workspace that contains a variable library. What can the user do with it?

  1. AOpen and view the variable library item
  2. BView and edit variable values
  3. CView, edit and reshare the variable library
  4. DEdit only the variables that they created
Show the answer and why
  • AOpen and view the variable library item

    Correct

    Viewers can view the variable library item.

  • BView and edit variable values

    Incorrect

    Editing needs the Contributor role or higher.

  • CView, edit and reshare the variable library

    Incorrect

    Resharing needs the Member or Admin role.

  • DEdit only the variables that they created

    Incorrect

    There's no permission management at the variable level.

Variable library permissions align with workspace roles: Viewers can view the item, Contributors can view, add, edit and delete it, and Members and Admins can also reshare it. Permissions apply to the whole item; there's no permission management per variable.

Practice domain 1 →Practice all domains →