Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You manage a Microsoft Fabric workspace that contains a data warehouse named SalesDW. Your DevOps team wants every table, view, and stored procedure in the warehouse to be stored in a Git repository so that schema changes can be reviewed and deployed through an Azure DevOps pipeline to test and production workspaces. What is the most appropriate first step to create a deployable artifact that captures the current warehouse schema?

  • Use Visual Studio Code with the SQL Database Projects extension to import SalesDW and build a .dacpac file.

  • Execute a T-SQL BACKUP DATABASE command in a Fabric notebook and add the backup file to source control.

  • Export SalesDW from the Fabric portal as a Power BI project (.pbip) and push it to the Git repository.

  • Generate an Azure Resource Manager (ARM) template for the warehouse item from the Azure portal and store it in Git.

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