Question

Your team uses a Fabric deployment pipeline with three stages: Development, Test, and Production. A data pipeline in the workspace uses a copy activity that connects to a SQL source. In Development the connection points to a dev SQL server, but after deploying to Production the item must automatically point to the production SQL server without any manual edits after each deployment. What should you configure to ensure the correct server is always used in the Production stage?

Accepted Answer

Create a deployment rule on the Production stage that parameterizes the data pipeline's connection to the production SQL server.

Answer

Manually update the connection in the Production workspace after every deployment.

Answer

Enable a Git branch for the Production stage and change the server value in the pipeline JSON before each merge.

Answer

Add a sensitivity label to the Production data pipeline so it uses the correct server.