Microsoft Implementing Analytics Solutions Using Microsoft Fabric DP-600 Exam Questions

Page: 1 / 14
Total 192 questions
Question 1

You have a Fabric workspace named Workspace1 and a user named User1. You need to ensure that User1 can perform the following tasks in Workspace1:

* Create dashboards.

* Publish semantic models.

* Create and publish reports.

The solution must follow the principle of least privilege. Which workspace role should you assign to User1?



Answer : C


Question 2

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?



Answer : A


Question 3

You need to recommend which type of fabric capacity SKU meets the data analytics requirements for the Research division. What should you recommend?



Answer : B


Question 4

You have a Fabric workspace named Workspace1 and a warehouse named Warehouse1. Workspace1 contains a user named User1. User1 is assigned the Viewer role for Workspace1.

You need to ensure that User1 can share Warehouse1 with other users. The solution must follow the principle of least privilege.

Which role should you assign to User1?



Answer : A


Question 5

You need to implement the date dimension in the data store. The solution must meet the technical requirements.

What are two ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.



Answer : A, B

Both a dataflow (A) and a Stored procedure activity in a pipeline (B) are capable of creating and populating a date dimension table. A dataflow can perform the transformation needed to create the date dimension, and it aligns with the preference for using low-code tools for data ingestion when possible. A Stored procedure could be written to generate the necessary date dimension data and executed within a pipeline, which also adheres to the technical requirements for the PoC.


Question 6

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

You need to ensure that User1 can perform the following tasks:

Create a new domain.

Create two subdomains named subdomain1 and subdomain2.

Assign Workspace1 to subdomain1.

Assign Workspace2 to subdomain2.

The solution must follow the principle of least privilege.

Which role should you assign to User1?



Answer : A

User1 must be able to:

Create a new domain.

Create two subdomains.

Assign Workspace1 to subdomain1.

Assign Workspace2 to subdomain2.

Key Role Definitions in Fabric:

Domain admin: Can manage domain settings, add/remove workspaces, manage contributors.

Domain contributor: Can contribute to an existing domain but cannot create a domain.

Workspace admin: Only controls permissions/settings inside a workspace, not domains.

Fabric admin: Tenant-wide admin, broader than required.

Requirement: Follow least privilege.

To create a new domain Requires Domain admin.

To assign workspaces to subdomains Domain admin rights are sufficient.

Fabric admin is excessive and breaks least privilege.

Correct Answe r: A . Domain admin


Question 7

You have a Fabric tenant.

You are creating a Fabric Data Factory pipeline.

You have a stored procedure that returns the number of active customers and their average sales for the current month.

You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.

Which type of activity should you add?



Answer : A

In a Fabric Data Factory pipeline, to execute a stored procedure and make the returned values available for downstream activities, the Lookup activity is used. This activity can retrieve a dataset from a data store and pass it on for further processing. Here's how you would use the Lookup activity in this context:

Add a Lookup activity to your pipeline.

Configure the Lookup activity to use the stored procedure by providing the necessary SQL statement or stored procedure name.

In the settings, specify that the activity should use the stored procedure mode.

Once the stored procedure executes, the Lookup activity will capture the results and make them available in the pipeline's memory.

Downstream activities can then reference the output of the Lookup activity.


Page:    1 / 14   
Total 192 questions