Question
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 need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort.
What should you use?
- A. a database project
- B. a deployment pipeline Correct
- C. a Python script
- D. a T-SQL script
Explanation
A Fabric deployment pipeline deploys a warehouse to the target workspace with DacFx-based schema deployment, which resolves object dependencies during deployment. If an object references something that does not exist, the deployment reports the problem. You get the check as part of the deployment itself without building anything extra. A database project can also find unresolved references when it is built, but you have to set up and maintain it separately. A custom Python or T-SQL script takes the most development effort.
