DP-600 Practice Online

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.  

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution? 

You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 contains a Delta table named Customer. When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table. You need to identify whether maintenance tasks were performed on Customer. Solution: You run the following Spark SQL statement: DESCRIBE HISTORY customer Does this meet the goal? 

You have a Fabric tenant that contains a warehouse named DW1 and a lakehouse named LH1. DW1 contains a table named Sales.Product. LH1 contains a table named Sales.Orders. You plan to schedule an automated process that will create a new point-in-time (PIT) table named Sales.ProductOrder in DW1. Sales.ProductOrder will be built by using the results of a query that will join Sales.Product and Sales.Orders. You need to ensure that the types of columns in Sales. ProductOrder match the column types in the source tables. The solution must minimize the number of operations required to create the new table. Which operation should you use?

You have a Fabric workspace named Workspace1 and a warehouse named Warehouse1. Workspace1

contains a user named User1. User1 is assigned the Viewer role for Workspace1.

You need to ensure that User1 can share Warehouse1 with other users. The solution must follow the

principle of least privilege.

Which role should you assign to User1?