Your team is developing a Fabric database project. You need to ensure that every schema change is tracked and that the team can compare the current schema with the version from last month. What should you implement?

Enable Fabric's automatic item versioning for the database.

Keep a backup of the production database every week.

Use a shared Excel spreadsheet to log schema changes manually.

Store the database project in a Git repository and tag releases with version numbers.

A company uses Fabric deployment pipelines to promote content. They have a requirement that all deployments to Production must be traceable to a specific Git commit. What should they implement?

Deploy directly from the Git repository without using a deployment pipeline.

Enable Fabric's audit log to capture deployment events.

Use a shared Excel file to log which commit was deployed.

Tag the Git repository with the release version and record it in the deployment pipeline metadata.

A data team manages a dimensional model in Fabric. They want to treat the database schema as code, review changes before they are applied, and track the history of schema modifications. Which approach should they use?

Use the Fabric web editor to alter tables directly in the production workspace.

Maintain a Word document listing all schema changes and share it via email.

Export the database to a CSV file after every change and store it in OneDrive.

Create a Fabric database project and connect it to a Git repository.

A data platform team wants to implement continuous deployment for Fabric items. They have a CI pipeline that builds and validates changes. They want to deploy to a Test workspace automatically, but only after a manual approval for Production. Which approach should they use?

Deploy to Test and Production simultaneously without any gates.

Deploy only to Production and skip Test to save time.

Use a single deployment pipeline with automatic deployment to Test and a manual approval gate before Production.

Use two separate pipelines: one for Test and one for Production, both triggered automatically.

A company needs to version their Fabric database schema and automatically deploy changes to a development environment when a pull request is merged. What should they implement?

A database project in Git with a CI/CD pipeline that deploys on merge to main.

A Power BI report that lists all schema changes.

A Fabric pipeline that copies the database every time a change is made.

A manual process where a DBA runs SQL scripts from a shared folder.

Microsoft Certified:Fabric Data Engineer Associate

Domain 1Objective 2

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

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 1–5

1application · medium
Your team is developing a Fabric database project. You need to ensure that every schema change is tracked and that the team can compare the current schema with the version from last month. What should you implement?
Select an answer first
2expert · hard
A company uses Fabric deployment pipelines to promote content. They have a requirement that all deployments to Production must be traceable to a specific Git commit. What should they implement?
Select an answer first
3application · medium
A data team manages a dimensional model in Fabric. They want to treat the database schema as code, review changes before they are applied, and track the history of schema modifications. Which approach should they use?
Select an answer first
4expert · hard
A data platform team wants to implement continuous deployment for Fabric items. They have a CI pipeline that builds and validates changes. They want to deploy to a Test workspace automatically, but only after a manual approval for Production. Which approach should they use?
Select an answer first
5application · medium
A company needs to version their Fabric database schema and automatically deploy changes to a development environment when a pull request is merged. What should they implement?
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.