Winter Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

DP-600 Sample Questions Answers

Questions 4

You have a Microsoft Power Bl semantic model.

You need to identify any surrogate key columns in the model that have the Summarize By property set to a value other than to None. The solution must minimize effort.

What should you use?

Options:

A.

DAX Formatter in DAX Studio

B.

Model view in Microsoft Power Bl Desktop

C.

Model explorer in Microsoft Power Bl Desktop

D.

Best Practice Analyzer in Tabular Editor

Buy Now
Questions 5

You have a Fabric tenant that contains a lakehouse named Lakehouse1.

You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse.

What should you configure? (5)

Options:

A.

the semantic model settings

B.

the Lakehouse1 settings

C.

the workspace settings

D.

the SQL analytics endpoint settings

Buy Now
Questions 6

You have a Fabric tenant that contains a warehouse.

Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse.

What should you use to identify whether throttling is occurring?

Options:

A.

the Capacity settings

B.

the Monitoring hub

C.

dynamic management views (DMVs)

D.

the Microsoft Fabric Capacity Metrics app

Buy Now
Questions 7

You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity.

You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege.

Which three actions in the Fabric Admin portal should you include in the recommendation? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

Options:

A.

From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled

B.

From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled

C.

From the Tenant settings, select Users can edit data models in the Power Bl service.

D.

From the Capacity settings, set XMLA Endpoint to Read Write

E.

From the Tenant settings, set Users can create Fabric items to Enabled

F.

From the Tenant settings, enable Publish to Web

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 lakehouse named Lakehousel. Lakehousel contains a Delta table named Customer.

When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.

You need to identify whether maintenance tasks were performed on Customer.

Solution: You run the following Spark SQL statement:

DESCRIBE DETAIL customer

Does this meet the goal?

Options:

A.

Yes

B.

No

Buy Now
Questions 9

You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.

You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return the total amount of sales from the same period last year.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 10

You have a Microsoft Power B1 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?

Options:

A.

Add a managed identity to the workspace.

B.

Add a managed identity to App1.

C.

Upgrade the workspace to Premium capacity.

D.

Modify the XMLA Endpoint setting.

Buy Now
Questions 11

You have a Microsoft Power Bl report named Report1 that uses a Fabric semantic model.

Users discover that Report1 renders slowly.

You open Performance analyzer and identify that a visual named Orders By Date is the slowest to render. The duration breakdown for Orders By Date is shown in the following table.

What will provide the greatest reduction in the rendering duration of Report1?

Options:

A.

Change the visual type of Orders By Dale.

B.

Enable automatic page refresh.

C.

Optimize the DAX query of Orders By Date by using DAX Studio.

D.

Reduce the number of visuals in Report1.

Buy Now
Questions 12

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.

Options:

Buy Now
Questions 13

You need to migrate the Research division data for Productline2. The solution must meet the data preparation requirements. How should you complete the code? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 14

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

Options:

A.

EM

B.

F

C.

P

D.

A

Buy Now
Questions 15

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
Questions 16

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.

Options:

Buy Now
Questions 17

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.

Switch

B.

Lookup

C.

Append variable

D.

KQL

Buy Now
Questions 18

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 19

NO: 8

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 20

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.

Options:

Buy Now
Questions 21

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.

Options:

Buy Now
Questions 22

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 23

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 24

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.

Options:

Buy Now
Exam Code: DP-600
Exam Name: Implementing Analytics Solutions Using Microsoft Fabric
Last Update: Feb 15, 2025
Questions: 117
$70  $174.99
$54  $134.99
$46  $114.99
buy now DP-600