Free DP-600 Exam Questions and Answers | by Exam-Dumps.net (Page: 7)

QUESTION: 31

HOTSPOT (Drag and Drop is not supported)
You have the source data model shown in the following exhibit.
The primary keys of the tables are indicated by a key symbol beside the columns involved in each key.
You need to create a dimensional data model that will enable the analysis of order items by date, product, and customer.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 32

You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following fields.
You need to reduce the memory used by Model1 and the time it takes to refresh the model.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

Split OrderDateTime into separate date and time columns.
Replace TotalQuantity with a calculated column.
Convert Quantity into the Text data type.
Replace TotalSalesAmount with a measure.

Answer(s): A,D

Reveal Solution Next Question

QUESTION: 33

You have a Fabric tenant that contains a semantic model.
You need to prevent report creators from populating visuals by using implicit measures.
What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.

Microsoft Power BI Desktop
Tabular Editor
Microsoft SQL Server Management Studio (SSMS)
DAX Studio

Answer(s): A,B

Reveal Solution Next Question

QUESTION: 34

HOTSPOT (Drag and Drop is not supported)
You have a Fabric tenant that contains two LakeHouses.
You are building a dataflow that will combine data from the LakeHouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 35

You have a Fabric tenant that contains a LakeHouse named Lakehouse’. Lakehouse1 contains a table named Tablet.
You are creating a new data pipeline.
You plan to copy external data to Table’. The schema of the external data changes regularly.
You need the copy operation to meet the following requirements:
Replace Table1 with the schema of the external data.
Replace all the data in Table1 with the rows in the external data.
You add a Copy data activity to the pipeline.
What should you do for the Copy data activity?

From the Source tab, add additional columns.
From the Destination tab, set Table action to Overwrite.
From the Settings tab, select Enable staging.
From the Source tab, select Enable partition discovery.
From the Source tab, select Recursively.

Answer(s): B

Reveal Solution Next Question

Microsoft DP-600 Exam (page: 7) Microsoft Implementing Analytics Solutions Using Fabric Updated on: 28-Jul-2025

QUESTION: 31

Explanation:

QUESTION: 32

QUESTION: 33

QUESTION: 34

Explanation:

QUESTION: 35

Microsoft DP-600 Exam (page: 7)
Microsoft Implementing Analytics Solutions Using Fabric
Updated on: 28-Jul-2025