You have a shared semantic model that is used by multiple reports. You need to update the model to fix a calculation error in a measure. You want to ensure that all reports automatically use the corrected measure without requiring any action from report owners. What should you do?

Send a .pbit file to report owners and ask them to import it.

Use the XMLA endpoint to update the measure in each report's local model.

Create a new semantic model and ask report owners to update their data sources.

Update the measure in the shared semantic model and republish it.

Your organization has a semantic model in a Fabric workspace that is consumed by multiple reports. You need to deploy an updated version of the model to production without disrupting the reports that are currently running. The update includes a new measure and a change to an existing table's column name. What is the best approach?

Create a new semantic model in the same workspace and update all report data sources to point to it.

Deploy the updated model to a separate workspace, validate it, and then swap the workspace using a deployment pipeline.

Update the model in place using Power BI Desktop and republish to the same workspace.

Use the XMLA endpoint to overwrite the production model directly during off-peak hours.

You are setting up a deployment pipeline for a Fabric solution that includes a dataflow and a semantic model. The dataflow refreshes data from an on-premises source, and the semantic model depends on the dataflow. You need to ensure that the deployment pipeline can deploy both items and that the semantic model refreshes after the dataflow. What should you do?

Use the REST API to deploy the dataflow and then manually refresh the semantic model.

Create two separate pipelines: one for the dataflow and one for the semantic model.

Deploy the semantic model first, then the dataflow, using the XMLA endpoint.

Assign the workspace to the deployment pipeline and configure the dataflow and semantic model in the same pipeline stage.

You are designing a deployment pipeline for a Fabric solution that includes a lakehouse, a dataflow, and a semantic model. The pipeline must support a hotfix process where a change is made directly in the Production stage and then back-ported to Development. What is the best way to configure the pipeline?

Create a separate pipeline for hotfixes that deploys from Production to Development.

Use the deployment pipeline to deploy from Development to Test to Production, and for hotfixes, manually copy the changed item from Production back to Development.

Disable the deployment pipeline for the Production stage and make all changes directly in Production.

Use Git integration to manage the hotfix by committing the change to a hotfix branch and merging it back to the main branch.

Your team develops semantic models and reports in a Fabric workspace. You need to promote content from development to test and then to production, but you want to avoid manually reconfiguring connections and parameters at each stage. You also need to ensure that test and production use different data sources. What should you implement?

Create a separate Git branch for each environment and merge changes manually.

Use the XMLA endpoint to script the deployment of semantic models to each workspace.

Create a deployment pipeline with three stages and configure dataset parameters for each stage.

Manually republish the .pbix files to each workspace and update data source credentials.

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 1Objective 2

Maintain the Analytics Development Lifecycle DP-600 Practice Questions (Page 8)

Part of the Maintain a data analytics solution domain, which accounts for 25–30% of the DP-600 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 5–10 from this objective — we provide 42 practice questions to prepare you well beyond it. (estimate)

42questions here

9free pages

8concepts

25–30%of the exam

Questions 36–40

36application · medium
You have a shared semantic model that is used by multiple reports. You need to update the model to fix a calculation error in a measure. You want to ensure that all reports automatically use the corrected measure without requiring any action from report owners. What should you do?
Select an answer first
37application · medium
Your organization has a semantic model in a Fabric workspace that is consumed by multiple reports. You need to deploy an updated version of the model to production without disrupting the reports that are currently running. The update includes a new measure and a change to an existing table's column name. What is the best approach?
Select an answer first
38application · medium
You are setting up a deployment pipeline for a Fabric solution that includes a dataflow and a semantic model. The dataflow refreshes data from an on-premises source, and the semantic model depends on the dataflow. You need to ensure that the deployment pipeline can deploy both items and that the semantic model refreshes after the dataflow. What should you do?
Select an answer first
39expert · hard
You are designing a deployment pipeline for a Fabric solution that includes a lakehouse, a dataflow, and a semantic model. The pipeline must support a hotfix process where a change is made directly in the Production stage and then back-ported to Development. What is the best way to configure the pipeline?
Select an answer first
40application · medium
Your team develops semantic models and reports in a Fabric workspace. You need to promote content from development to test and then to production, but you want to avoid manually reconfiguring connections and parameters at each stage. You also need to ensure that test and production use different data sources. What should you implement?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-600

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-600” is a trademark of its owner, used for identification only.

Maintain the Analytics Development Lifecycle DP-600 Practice Questions (Page 8)

Questions 36–40

You have a shared semantic model that is used by multiple reports. You need to update the model to fix a calculation error in a measure. You want to ensure that all reports automatically use the corrected measure without requiring any action from report owners. What should you do?

Keep studying — Maintain a data analytics solution