Mark, the CTO of MDFT Pro, a well-known training agency, has asked you to manage the warehouse deployments.
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 Python script is incorrect. Python scripts require custom development effort and don't provide built-in validation.
a database project is incorrect. Database projects require significant setup and are not needed for simple reference validation.
a deployment pipeline is correct. Deployment pipelines automatically validate references and report issues with minimal configuration.
a T-SQL script is incorrect. T-SQL scripts can query metadata but don't automatically validate cross-item references.