DP-600 Free Practice Questions

Question 1

You have a Fabric workspace named Workspace1 that contains the following items: • A warehouse named Warehouse1 • A semantic model named Model1 • An interactive report named Report1 You need to allow a user named User1 to access a single table in Warehouse1. The solution must follow the principle of least privilege. What should you do first?

Question 2

You have a Fabric tenant that contains a semantic model named Model1. Model1 contains a fact table named FactSales. FactSales has a relationship to a dimension table named DimDate on a column named OrderDate. To FactSales, you add a second relationship between FactSales and DimDate based on a column named ShippedDate. You need to filter by using ShippedDate in a new report. The solution must NOT affect the function of existing reports. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Question 3

You have a Microsoft Power BI semantic model that contains a table named Date. Date contains the following data. You need to ensure that the visuals that use the Date table appear in chronological order. The solutions must minimize administrative effort. What should you do?

Question 4

You have a Fabric workspace named Workspace1 that contains a semantic model and a report named Report1. Workspace1 is connected to a Git repository named Git1. You have a deployment pipeline that contains three stages named Development, Test, and Production. You need to publish Report1 to the Production stage. What should you do?

Question 5

You have a Fabric workspace named Workspace1 and a user named User1. You need to ensure that User1 can perform the following tasks in Workspace1: • Create dashboards. • Publish semantic models. • Create and publish reports. The solution must follow the principle of least privilege. Which workspace role should you assign to User1?

Question 6

You are designing a Fabric semantic model named Model1 for a financial analytics workspace. Model1 includes a DAX measure named Measure1 that returns total sales. You have a table named Currency that contains a column named Format. The Format column defines currency formatting strings for each record as follows: $#, ##0.00, €#, ##0.00, OR ¥#,##0.00. You have a report that uses the Currency column to identify which symbol and format string to display. In the report, Measure1 must appear with two decimal places and the appropriate currency symbol based on the selected value in the Currency column. You create the following DAX formula. FORMAT = SELECTEDVALUE( ‘Currency’ [Format]) You need to ensure that Measure appears correctly in visuals. The solution must minimize logic duplication. What should you do?

Question 7

You have an Azure SQL database named DB1 and a Fabric workspace named Workspace1. Workspace1 contains a lakehouse named LH1 and a Dataflow Gen2 named Dataflow1. Dataflow1 includes a query named Query1 that loads data from DB1, applies transformations to the data, and then filters the data. You discover that Query1 loads all the data before applying the transformations. You need to ensure that Query1 uses query folding. What should you do?

Question 8

DRAG DROP - You have Fabric tenant that contains a semantic model named Model1. Model1 contains the following tables. You are designing a Microsoft Power BI report named Report1 that will deliver near-real-time (NRT) shipping data. Report1 will contain data about many shipped packages. You need to ensure that each table is in the appropriate storage mode to support Report1. The solution must support near-real-time data delivery while maintaining high query performance. Which storage mode should you select for each table? To answer, drag the appropriate storage modes to the correct tables. Each mode 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 9

You have a Fabric workspace named Workspace1. You have a GitHub repository named Repo1. You need to connect Workspace1 to the main branch of Repo1. Which information should you provide?

Question 10

DRAG DROP - You have Fabric tenant that contains four workspaces named Development, Test, QA, and Production. All the workspaces are in Premium Per User (PPU) license mode. You plan to use a release pipeline to support the development lifecycle from Development to Production. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.