Microsoft Fabric Data Engineer Associate DP-700 Practice Question
Dev and Test workspaces each contain a lakehouse, semantic model, and reports. The Dev workspace is assigned to the Dev stage of a Fabric deployment pipeline. During deployment to Test, the semantic model must automatically switch its SQL endpoint from dev-sql.fabric.microsoft.com to test-sql.fabric.microsoft.com without manual edits. Which action should you configure in the pipeline?
Insert an additional validation stage between Dev and Test and deploy to that stage first.
Edit the Test workspace settings to use the test SQL endpoint after the deployment completes.
Add a scheduled refresh rule to the semantic model before deploying to the Test stage.
Create a data-source rule that replaces the semantic model's connection string with test-sql.fabric.microsoft.com for the Test stage.
Deployment pipelines let you add stage-specific rules that modify item properties. For a semantic model, a data-source rule can remap the SQL endpoint. Creating a rule that maps dev-sql.fabric.microsoft.com to test-sql.fabric.microsoft.com ensures the Test stage uses the correct server automatically. Scheduled refresh rules, workspace-level edits, or adding a new stage do not update the connection string during deployment.
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 are data-source rules in deployment pipelines?
Open an interactive chat with Bash
Why is a data-source rule better than a scheduled refresh rule in this scenario?
Open an interactive chat with Bash
How does stage-specific configuration work in Fabric deployment pipelines?
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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .