Free Microsoft DP-600 Practice Exam with Questions & Answers | Set: 2

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?

You have a Fabric tenant.

You need to configure OneLake security for users shown in the following table.

The solution must follow the principle of least privilege.

Which permission should you assign to each user? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements:

• Ensure that the developers can deploy items to the workspaces for Development and Test.

• Prevent the developers from deploying items to the workspace for Production.

• Follow the principle of least privilege.

Which three levels of access should you assign to the developers? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2.

Workspace1 is used as the development environment.

Workspace2 is used as the production environment.

Each environment uses a different storage account.

Workspace1 contains a Dataflow Gen2 named Dataflow1. The data source of Dataflow1 is a CSV file in blob storage.

You plan to implement a deployment pipeline to deploy items from Workspace1 to Workspace2.

You need to ensure that the data source references the correct location in the production environment.

What should you do?

You have a Fabric workspace named Workspace1 that contains an eventstream named Eventstream1.

Eventstream1 reads data from an Azure event hub named Eventhub1.

Eventhub1 contains the following columns.

Name

Data type

MachineId

Int

Payload

Dynamic

Datetime

Datetime

Location

String

You need to add a continuous percentile calculation to the Payload column. The solution must minimize development effort.

What should you do?

You plan to use Fabric to store data.

You need to create a data store that supports the following:

• Writing data by using T-SQL

• Multi-table transactions

• Dynamic data masking

Which type of data store should you create?

You have a Fabric tenant that contains a semantic model named Modell. Model! contains the following tables.

Product and Store can be part of multiple campaigns, and multiple active campaigns can exist simultaneously. You plan to create a report named Report1 that will display sales made after a campaign for a given store. You need to add a table to Modell and configure cardinality for the tables relationships. What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Fabric workspace named Workspacel that uses the Premium Per User (PPU) license mode and contains a semantic model named Model1.

Large semantic model storage format is selected for Model 1.

You need to ensure that tables imported into Modell are written automatically to Delta tables in OneLake.

What should you do for Modell and Workspacel? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Your company has a finance department.

You have a Fabric tenant, an Azure Storage account named storagel, and a Microsoft Entra group named Groupl. Groupl contains the users in the finance department.

You need to create a new workspace named Workspacel in the tenant. The solution must meet the following requirements:

• Ensure that the finance department users can create and edit items in Workspace " !.

• Ensure that Workspacel can securely access storagel to read and write data.

• Ensure that you are the only admin of Workspacel.

• Minimize administrative effort.

You create Workspacel.

Which two actions should you perform next? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains two users named User1 and User2.

You have a Fabric tenant that has certification and master data endorsement enabled. User2 ts configured as an authorized receiver for certification and master data endorsement. The tenant contains a workspace named Workspace V Workspace1 contains the following items:

• A semantic model named Model1

o User1 is the owner of Modell and is assigned write access to the model

• A lakehouse named LH1 mat stores the customer master data