Question 21

You have an Azure Repos Git repository named Repo1 and a Fabric-enabled Microsoft Power Bl Premium capacity. The capacity contains two workspaces named Workspace! and Workspace2. Git integration is enabled at the workspace level.
You plan to use Microsoft Power Bl Desktop and Workspace! to make version-controlled changes to a semantic model stored in Repo1. The changes will be built and deployed lo Workspace2 by using Azure Pipelines.
You need to ensure that report and semantic model definitions are saved as individual text files in a folder hierarchy. The solution must minimize development and maintenance effort.
In which file format should you save the changes?
  • Question 22

    You have a Microsoft Power BI Premium Per User (PPU) workspace that contains a semantic model.
    You have an Azure App Service app named App1 that modifies row-level security (RLS) for the model by using the XMLA endpoint.
    App1 requires users to sign in by using their Microsoft Entra credentials to access the XMLA endpoint.
    You need to configure App1 to use a service account to access the model.
    What should you do first?
  • Question 23

    You have a Fabric tenant that contains a workspace named Workspace1.
    You plan to deploy a semantic model named Model1 by using the XMLA endpoint.
    You need to optimize the deployment of Model1. The solution must minimize how long it takes to deploy Model1.
    What should you do in Workspace1?
  • Question 24

    You are analyzing customer purchases in a Fabric notebook by using PySpanc You have the following DataFrames:

    You need to join the DataFrames on the customer_id column. The solution must minimize data shuffling. You write the following code.

    Which code should you run to populate the results DataFrame?
  • Question 25

    You have a Fabric tenant that contains a warehouse.
    A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not rendered.
    You need to identify what is preventing the report query from completing.
    Which dynamic management view (DMV) should you use?