DP-600 Free Practice Questions — Page 2

Question 11

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1 and a user named User1. You need to ensure that User1 can read all the data in Lakehouse1. The solution must follow the principle of least privilege. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Question 12

You have a Fabric tenant. You need to create a semantic model that delivers fast report rendering, minimizes query latency, and maximizes flexibility for DAX calculations. Which storage mode should you select?

Question 13

You have a Microsoft Power BI semantic model that contains a single table named Orders. Orders contains the following columns: • Product Name • Order Date • Quantity You have a Power BI report that contains a page named Inventory. Inventory contains a slicer for the Product Name column and a clustered column chart that shows Quantity by Order Date. You need to ensure that users can select whether to display Quantity by Product Name or Quantity by Order Date in the chart. The solution must minimize development effort. What should you create?

Question 14

DRAG DROP - You have a Fabric lakehouse named Lakehouse1. You have the data sources shown in the following table. You need to ingest data from both data sources into Lakehouse1. The solution must minimize maintenance and development time. What should you use to ingest the data into each data source? To answer, drag the appropriate options to the correct data sources. Each option 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.

Question 15

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?

Question 16

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1. You share DW1 with User1 and assign User1 the default permissions for DW1. What can User1 do?

Question 17

You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2. Workspace1 is used as the development environment. Workspace2 is used as the production environment. Each environment uses a different storage account. Workspace1 contains a Dataflow Gen2 named Dataflow1. The data source of Dataflow1 is a CSV file in blob storage. You plan to implement a deployment pipeline to deploy items from Workspace1 to Workspace2. You need to ensure that the data source references the correct location in the production environment. What should you do?

Question 18

HOTSPOT - You have a Fabric workspace named Workspace1 that uses the Premium Per User (PPU) license mode and contains a semantic model named Model1. Large semantic model storage format is selected for Model1. You need to ensure that tables imported into Model1 are written automatically to Delta tables in OneLake. What should you do for Model1 and Workspace1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 19

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

Question 20

DRAG DROP - You have a Fabric eventhouse named Eventhouse1 that contains a table named Weatherdata. A sample of the data in Weatherdata is shown in the following table. You plan to use a KQL queryset to manipulate the data in Eventhouse1. The result set must have the following columns. You need to build the query. Which four KQL statements should you use in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.