nerdexam
Microsoft

DP-700 · Question #117

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1. You plan to deploy Warehouse 1 to a new workspace named Workspace2. As part of the deployment process, you…

The correct answer is B. a deployment pipeline. The user needs to deploy a Fabric warehouse to a new workspace and verify invalid references with minimal effort and detailed information.

Implement and manage an analytics solution

Question

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1. You plan to deploy Warehouse 1 to a new workspace named Workspace2. As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort and provide detailed information about the invalid references. What should you use?

Options

  • Aa dbt project
  • Ba deployment pipeline
  • Ca Python script
  • Da database project

How the community answered

(30 responses)
  • A
    10% (3)
  • B
    83% (25)
  • C
    3% (1)
  • D
    3% (1)

Why each option

The user needs to deploy a Fabric warehouse to a new workspace and verify invalid references with minimal effort and detailed information.

Aa dbt project

A dbt project (data build tool) is primarily used for data transformation and modeling, not for validating references between Fabric workspace items during deployment.

Ba deployment pipelineCorrect

A deployment pipeline in Microsoft Fabric is designed for deploying content between workspaces and automatically validates items for issues like invalid references during the deployment process, providing detailed error messages if any are found. This approach minimizes development effort compared to custom scripting or external tools and is an integrated solution for lifecycle management.

Ca Python script

A Python script could potentially check references, but it would require significant development effort to parse Fabric item definitions and identify invalid references, which doesn't meet the 'minimize development effort' requirement.

Da database project

A database project (like SQL Server Database Project) is used for source control and deployment of relational database schemas, but it is not directly integrated with Fabric's item validation for deployment across workspaces.

Concept tested: Microsoft Fabric deployment pipelines and item validation

Source: https://learn.microsoft.com/fabric/cicd/deployment-pipelines/overview-deployment-pipelines

Topics

#Fabric Deployment Pipelines#Data Warehouse Deployment#Pre-deployment Validation#Workspace Management

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice