DP-600 Practice Test

DP-600 Practice Test practice questions, page 7 of 9, with answer review and explanations.

Question 31

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.

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.

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

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.

  1. Microsoft Power BI Desktop
  2. Tabular Editor
  3. Microsoft SQL Server Management Studio (SSMS)
  4. DAX Studio

Question 34

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.

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?

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