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

Question

Options

• Aa database project
• Ba deployment pipeline
• Ca Python script
• Da T-SQL script

• A
  5% (2)
• B
  82% (31)
• C
  11% (4)
• D
  3% (1)

Explanation

A Deployment Pipeline in Microsoft Fabric is the correct answer because it is a built-in, low-code Fabric feature designed specifically for promoting items (including Warehouses) across workspaces - typically representing dev, test, and production stages. Before a deployment is executed, the deployment pipeline performs automatic validation that surfaces invalid references, broken dependencies, and other configuration issues between the source and target workspaces. This requires zero custom development, satisfying the 'minimize development effort' requirement. A Database Project (SqlProj/SSDT) can validate schemas and references but requires authoring and maintaining project files. A Python or T-SQL script could query metadata to detect invalid references but would require significant custom development to replicate what deployment pipelines provide out of the box.

No community discussion yet for this question.