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

Questions 11–15

1. 11expert · hard

   You need to deploy a semantic model to a production workspace using the XMLA endpoint. The model is currently in a development workspace and has been tested. You want to minimize downtime and ensure that if the deployment fails, the production model remains unchanged. What is the best approach?

   • AOverwrite the production model directly using the XMLA endpoint.
   • BCreate a backup of the production model and then overwrite it.
   • CUse a deployment pipeline to deploy directly to production.
   • DDeploy the model to a staging workspace first, validate it, and then use the XMLA endpoint to swap the production model.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which of the following is a typical stage in a Fabric deployment pipeline?

   • ASandbox
   • BArchival
   • CStaging
   • DDevelopment
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   You are configuring a deployment pipeline for a Fabric solution that includes a lakehouse, a dataflow, and a semantic model. You want to ensure that when the semantic model is deployed to the next stage, it does not overwrite the data source credentials that were manually configured in that stage. What should you configure in the deployment pipeline?

   • ADisable the semantic model item in the deployment pipeline so it is never deployed.
   • BUse the XMLA endpoint to manually update credentials after each deployment.
   • CCreate a separate semantic model in each stage and link them manually.
   • DSet the data source credentials as a stage-level parameter and exclude them from the deployment rules.
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   You are a Fabric administrator. A shared semantic model is about to be changed: a column will be renamed and a measure will be removed. The model is consumed by 20 reports, some of which are in other workspaces. You need to minimize the risk of breaking reports while still making the change. You have the ability to edit the model via the XMLA endpoint. What should you do first?

   • AUse lineage view to identify all reports that use the model, then review each report for references to the column and measure.
   • BRename the column and remove the measure in the model, then check the reports for errors.
   • CCreate a new semantic model with the changes and migrate all reports to it.
   • DUse the XMLA endpoint to make the changes and then use the REST API to check report status.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   You need to deploy a semantic model to a Fabric workspace using the XMLA endpoint. The model is currently in a Power BI Desktop project (.pbip) and you want to automate the deployment as part of a CI/CD pipeline. What should you use?

   • AUse the deployment pipeline to deploy the .pbip file.
   • BTabular Editor to script the deployment and execute it via the XMLA endpoint.
   • CConvert the .pbip to a .pbit file and use the XMLA endpoint to import it.
   • DPower BI Desktop to publish the .pbip file directly to the workspace.
   Reveal Solution Discussion Select an answer first