Question

A data engineering team manages a Fabric warehouse and wants to track schema changes (tables, views, stored procedures) in source control and validate them locally before applying them to the warehouse. They need a build-time model that can detect schema drift and generate incremental deployment scripts as part of their CI/CD process. Which Fabric lifecycle management capability should they use?

Accepted Answer

Create a SQL database project for the warehouse and use it to build, compare, and publish schema changes

Answer

Connect the workspace to Git integration and rely on automatic commits of warehouse item definitions

Answer

Use a Fabric deployment pipeline with deployment rules to promote the warehouse between stages

Answer

Export the warehouse as a Dataflow Gen2 template and version the JSON definition manually