Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You manage a Microsoft Fabric deployment pipeline that contains Development, Test, and Production stages. A Dataflow Gen2 in the Development workspace connects to a SQL Server database named SalesDev. When the dataflow is promoted, it must automatically use the SalesTest database in the Test stage and the SalesProd database in the Production stage, without requiring you to edit the dataflow after each deployment. Which deployment-pipeline feature should you configure to meet this requirement?
Grant stage-level deployment permissions to override connections after deployment.
Apply endorsement labels to the dataflow at each stage.
Enable workspace mirroring so each stage inherits its own connections.
Define data-source rules for the dataflow in the deployment pipeline.
Deployment pipelines let you define rules that automatically change environment-specific settings as items move between stages. For Dataflow Gen2 artifacts, you can create a data-source rule that replaces the original connection string with a different one in each target stage. During deployment the rule updates the connection so the dataflow points to SalesTest in the Test stage and SalesProd in Production. Endorsements, permissions, and workspace mirroring do not modify internal connection settings, so they cannot redirect the dataflow to the correct databases.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a data-source rule in a deployment pipeline?
Open an interactive chat with Bash
How do deployment pipelines in Microsoft Fabric manage environment-specific settings?
Open an interactive chat with Bash
What are the benefits of using deployment pipelines for dataflows?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Implement and manage an analytics solution
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .