Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Microsoft DP-600 - Implementing Analytics Solutions Using Microsoft Fabric

Page: 1 / 3
Total 137 questions

You have a Microsoft Power Bl project that contains a semantic model. You plan to use Azure DevOps for version control.

You need to modify the .gitignore file to prevent the data values from the data sources from being pushed to the repository. Which file should you reference?

A.

unappliedChanges.json

B.

model.bim

C.

cache.abf

D.

localSettings.json

You have a Fabric tenant

You plan to create a data pipeline named Pipeline1. Pipeline1 will include two activities that will execute in sequence. You need to ensure that a failure of the first activity will NOT block the second activity. Which conditional path should you configure between the first activity and the second activity?

A.

Upon Completion

B.

Upon Success

C.

Upon Skip

D.

Upon Failure

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?

A.

Reference the columns in the Python code by index.

B.

Modify the Sort Column By property for all columns.

C.

Add a unique field to each row.

D.

Modify the Summarize By property for all columns.

You have a Fabric warehouse that contains a table named SalesOrderDetail. SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.

You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.

Which T-SQL statement should you run?

A)

B)

C)

D)

A.

Option

B.

Option

C.

Option

D.

Option

You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns.

You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row.

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.

You are creating a dataflow in Fabric to ingest data from an Azure SQL database by using a T-SQL statement.

You need to ensure that any foldable Power Query transformation steps are processed by the Microsoft SQL Server engine.

How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

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.

A.

Build permission to the production semantic models

B.

Admin access to the deployment pipeline

C.

Viewer access to the Development and Test workspaces

D.

Viewer access to the Production workspace

E.

Contributor access to the Development and Test workspaces

F.

Contributor access to the Production workspace

You have a Fabric workspace named Workspacel that contains a lakehouse named Lakehousel. Lakehousel contains a table named Tablel. Table 1 contains the following data.

You need to perform the following actions:

• Load the data from Table! into a star schema.

• Create a product dimension table named DimProduct and a fact table named FactSales.

Which three columns should you include in DimProduct?

A.

ProductColor, ProductID, and ProductName.

B.

ProductName, SalesAmount, andTransactionlD

C.

Date, ProductID, andTransactionlD.

D.

ProductID, ProductName, and SalesAmount

You have a Fabric tenant that contains a workspace named Workspace"!. You plan to deploy a semantic model named Model 1 by using the XMLA endpoint.

You need to optimize the deployment of Model!. The solution must minimize how long it takes to deploy Modell. What should you do in Workspace1?

A.

Select Small semantic model storage format.

B.

Select Users can edit data models in the Power Bl service.

C.

Select Large semantic model storage format

D.

Set Enable Cache for Shortcuts to On.

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.

You need to reduce the execution time of the query.

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

Does this meet the goal?

A.

Yes

B.

No