Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You maintain a database project (.sqlproj) that contains the Data Definition Language (DDL) scripts for a Microsoft Fabric Warehouse. The project is stored in Azure Repos Git. You need to configure an Azure DevOps CI/CD pipeline that will automatically:

  • Build the database project to produce a DACPAC file.
  • Compare the DACPAC with the target Fabric Warehouse through its T-SQL endpoint.
  • Apply only the required schema changes during deployment.

Which pipeline task or command should you add to perform the deployment to the Fabric Warehouse?

  • Add an Azure CLI task that calls the Microsoft Fabric REST API to import the DACPAC file as a dataflow.

  • Add an Azure SQL Database deployment task that runs the SqlPackage command with the Publish action against the warehouse's T-SQL endpoint.

  • Add a Power BI deployment pipeline task that promotes the workspace to the test stage.

  • Add a Copy Files task that copies all .sql script files to a blob container linked to the workspace.

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