DP-700 Implement and Manage an Analytics Solution Practice Question
You are configuring a deployment pipeline to move a Lakehouse from a Test workspace to a Production workspace. Which THREE types of deployment rules can you apply to ensure the Lakehouse functions correctly in the Production environment?
⚠ Common exam trap
Candidates frequently guess generic environment variables or workspace roles instead of the exact supported deployment rule types like data source, parameter, and secret rules.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Data source rules
Deployment rules are essential for tailoring Fabric items to their destination environment. For Lakehouses and semantic models, you can define rules that change the underlying data sources or parameters. This prevents the Production environment from accidentally referencing Test data and allows for a seamless transition that maintains data integrity and security across the lifecycle stages.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Data source rules
Why this is correct
Data source rules allow you to redirect connections from a test database to a production database. When the pipeline runs, Fabric automatically replaces the connection details in the Lakehouse or semantic model metadata, ensuring that the production environment always processes the correct, live business data instead of test datasets.
- ✓
Parameter rules
Why this is correct
Many Fabric items use parameters to define variables like folder paths, dates, or thresholds. Parameter rules allow you to override these values during deployment. For instance, you can set a 'FilePath' parameter to point to a production container in Azure Data Lake Storage when moving from Test to Production.
- ✗
Lakehouse name rules
Why it's wrong here
Fabric deployment pipelines do not currently support rules for renaming the Lakehouse item itself during deployment. The item name remains consistent across stages to maintain the lineage and internal GUID mapping. Changes to the item's display name must be done manually if absolutely necessary, though it's discouraged.
- ✗
User permission rules
Why it's wrong here
Deployment pipelines do not manage the synchronization or modification of user permissions or workspace roles. Security and access control must be managed separately in the destination workspace. Pipelines focus on the items and their internal configurations rather than the access control lists associated with the workspace itself.
- ✓
Azure Key Vault secret rules
Why this is correct
While often categorized under data sources or parameters, Fabric supports specific overrides for credentials and secrets. Ensuring that the Production stage uses a different secret from Key Vault than the Test stage is a critical security practice supported by the deployment engine to protect sensitive connection information.
About these practice questions
One of 152 original DP-700 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-700 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-700 exam.