Microsoft Implementing Analytics Solutions Using Microsoft Fabric (DP-600) - Microsoft Exam Questions

You have a Fabric tenant that contains a data pipeline. You need to ensure that the pipeline runs every four hours on Mondays and Fridays. To what should you set Repeat for the schedule?

You have a Fabric warehouse named Warehousel that contains a table named Table! Tablel contains customer data. You need to implement row-level security (RLS) for Tablel. The solution must ensure that users can

see only their respective data.

Which two objects should you create? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

HOTSPOT You have a Fabric warehouse that contains a table named Sales.Orders. Sales.Orders contains the



following columns. You need to write a T-SQL query that will return the following columns.



How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Does this meet the goal?

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:

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)