Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You use Microsoft Fabric and have linked your workspace to an Azure DevOps Git repository. A team of data engineers needs an offline development approach that lets them store the full table, view, and stored-procedure definitions for a Fabric warehouse in source control, validate schema changes during pull requests, and publish those changes through a CI/CD pipeline. They understand that, as of today, publishing to a Fabric warehouse from a DACPAC performs a full database re-deployment rather than an incremental, state-based update.

Which approach should you recommend?

  • Create lakehouse shortcuts that reference the warehouse delta tables and synchronize them through Git integration.

  • Create a SQL database project that targets Microsoft Fabric - Data Warehouse and use build and publish actions in your Azure DevOps pipeline.

  • Add the .pbip Power BI project for the warehouse to the repo and rely on workspace deployment pipelines to move changes.

  • Store all CREATE and ALTER scripts for the warehouse in a folder inside the repo and execute them in sequence from an Azure DevOps pipeline.

Microsoft Fabric Data Engineer Associate DP-700
Implement and manage an analytics solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot