DP-700 Question #117: Real Exam Question with Answer & Explanation

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

Explanation

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

Common mistakes.

• A. A dbt project (data build tool) is primarily used for data transformation and modeling, not for validating references between Fabric workspace items during deployment.
• C. 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.
• D. 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

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

No community discussion yet for this question.