Question

Your team uses a Fabric deployment pipeline with Development, Test, and Production stages. A semantic model connects to a lakehouse SQL analytics endpoint. When you deploy from Test to Production, the semantic model must automatically point to the Production lakehouse instead of the Test one, without anyone manually editing the model after each deployment. What should you configure?

Accepted Answer

A deployment rule on the Production stage that sets the semantic model's data source connection to the Production endpoint

Answer

A sensitivity label on the semantic model so it inherits the correct connection per stage

Answer

An impact analysis report on the Test stage before each deployment

Answer

Git integration on the Production workspace to override the connection string on commit