Summer Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

DP-600 Implementing Analytics Solutions Using Microsoft Fabric Questions and Answers

Questions 4

You have a Fabric tenant that contains a workspace named Workspace! Workspace1 uses the Pro license mode and contains a semantic model named Model1.

You have an Azure DevOps organization.

You need to enable version control for Workspace1. The solution must ensure that Model 1 is added to the repository.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

DP-600 Question 4

Options:

Buy Now
Questions 5

You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse. When users interact with a report built from the model, which mode will be used by the DAX queries?

Options:

A.

DirectQuery

B.

Dual

C.

Direct Lake

D.

Import

Buy Now
Questions 6

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?

Options:

A.

Script

B.

Copy data

C.

Switch

D.

Append variable

Buy Now
Questions 7

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains an unpartitioned table named Table1.

You plan to copy data to Table1 and partition the table based on a date column in the source data.

You create a Copy activity to copy the data to Table1.

You need to specify the partition column in the Destination settings of the Copy activity.

What should you do first?

Options:

A.

From the Destination tab, set Mode to Append.

B.

From the Destination tab, select the partition column,

C.

From the Source tab, select Enable partition discovery

D.

From the Destination tab, set Mode to Overwrite.

Buy Now
Questions 8

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Fabric tenant that contains a semantic model named Model1.

You discover that the following query performs slowly against Model1.

DP-600 Question 8

You need to reduce the execution time of the query.

Solution: You replace line 4 by using the following code:

DP-600 Question 8

Does this meet the goal?

Options:

A.

Yes

B.

No

Buy Now
Questions 9

You have a Fabric workspace that uses the default Spark starter pool and runtime version 1,2.

You plan to read a CSV file named Sales.raw.csv in a lakehouse, select columns, and save the data as a Delta table to the managed area of the lakehouse. Sales_raw.csv contains 12 columns.

You have the following code.

DP-600 Question 9

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

DP-600 Question 9

Options:

Buy Now
Questions 10

You have a Fabric warehouse named Warehousel that contains a table named Table! Tablel contains customer data.

You need to implement row-level security (RLS) for Tablel. The solution must ensure that users can see only their respective data.

Which two objects should you create? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

SECURITY POLICY

B.

STORED PROCEDURE

C.

DATABASE ROLE

D.

FUNCTION

E.

CONSTRAINT

Buy Now
Questions 11

You need to design a semantic model for the customer satisfaction report.

Which data source authentication method and mode should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-600 Question 11

Options:

Buy Now
Questions 12

What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?

Options:

A.

a stored procedure

B.

a pipeline that contains a KQL activity

C.

a Spark notebook

D.

a dataflow

Buy Now
Questions 13

Which type of data store should you recommend in the AnalyticsPOC workspace?

Options:

A.

a data lake

B.

a warehouse

C.

a lakehouse

D.

an external Hive metaStore

Buy Now
Questions 14

You to need assign permissions for the data store in the AnalyticsPOC workspace. The solution must meet the security requirements.

Which additional permissions should you assign when you share the data store? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-600 Question 14

Options:

Buy Now
Questions 15

You need to recommend a solution to prepare the tenant for the PoC.

Which two actions should you recommend performing from the Fabric Admin portal? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

Options:

A.

Enable the Users can try Microsoft Fabric paid features option for specific security groups.

B.

Enable the Allow Azure Active Directory guest users to access Microsoft Fabric option for specific security groups.

C.

Enable the Users can create Fabric items option and exclude specific security groups.

D.

Enable the Users can try Microsoft Fabric paid features option for the entire organization.

E.

Enable the Users can create Fabric items option for specific security groups.

Buy Now
Questions 16

You need to resolve the issue with the pricing group classification.

How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-600 Question 16

DP-600 Question 16

Options:

Buy Now
Questions 17

You have a Fabric workspace that contains a Dataflow Gen2 query. The query returns the following data.

DP-600 Question 17

You need to filter the results to ensure that only the latest version of each customer's record is retained. The solution must ensure that no new columns are loaded to the semantic model.

Which four actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

DP-600 Question 17

Options:

Buy Now
Questions 18

You have a Fabric tenant that contains a data warehouse named DW1. DW1 contains a table named DimCustomer. DimCustomer contains the fields shown in the following table.

DP-600 Question 18

You need to identify duplicate email addresses in DimCustomer. The solution must return a maximum of 1,000 records.

Which four T-SQL statements should you run in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

DP-600 Question 18

Options:

Buy Now
Questions 19

You have a Fabric tenant.

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

DP-600 Question 19

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.

DP-600 Question 19

Options:

Buy Now
Questions 20

You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.

DP-600 Question 20

What can you identify about the pickupLongitude column?

Options:

A.

The column has duplicate values.

B.

All the table rows are profiled.

C.

The column has missing values.

D.

There are 935 values that occur only once.

Buy Now
Questions 21

You need to recommend a solution to group the Research division workspaces.

What should you include in the recommendation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-600 Question 21

Options:

Buy Now
Questions 22

What should you use to implement calculation groups for the Research division semantic models?

Options:

A.

DAX Studio

B.

Microsoft Power Bl Desktop

C.

the Power Bl service

D.

Tabular Editor

Buy Now
Questions 23

Which syntax should you use in a notebook to access the Research division data for Productlinel?

A)

DP-600 Question 23

B)

DP-600 Question 23

C)

DP-600 Question 23

D)

DP-600 Question 23

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 24

You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements. What should you do?

Options:

A.

Store all the semantic models and reports in Data Lake Gen2 storage.

B.

Modify the settings of the Research workspaces to use a GitHub repository.

C.

Store all the semantic models and reports in Microsoft OneDrive.

D.

Modify the settings of the Research division workspaces to use an Azure Repos repository.

Buy Now
Questions 25

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?

Options:

A.

an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse

B.

an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse

C.

an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse

D.

an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderiD column m the

destination lakehouse

Buy Now
Questions 26

You need to create a DAX measure to calculate the average overall satisfaction score.

How should you complete the DAX code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-600 Question 26

DP-600 Question 26

Options:

Buy Now
Questions 27

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.

Options:

A.

Populate the date dimension table by using a dataflow.

B.

Populate the date dimension table by using a Stored procedure activity in a pipeline.

C.

Populate the date dimension view by using T-SQL.

D.

Populate the date dimension table by using a Copy activity in a pipeline.

Buy Now
Questions 28

You need to ensure the data loading activities in the AnalyticsPOC workspace are executed in the appropriate sequence. The solution must meet the technical requirements.

What should you do?

Options:

A.

Create a pipeline that has dependencies between activities and schedule the pipeline.

B.

Create and schedule a Spark job definition.

C.

Create a dataflow that has multiple steps and schedule the dataflow.

D.

Create and schedule a Spark notebook.

Buy Now
Exam Code: DP-600
Exam Name: Implementing Analytics Solutions Using Microsoft Fabric
Last Update: Jul 26, 2025
Questions: 140

PDF + Testing Engine

$74.6  $186.49

Testing Engine

$59.8  $149.49
buy now DP-600 testing engine

PDF (Q&A)

$55  $137.49
buy now DP-600 pdf