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

You have a Microsoft Power Bl semantic model that contains measures. The measures use multiple calculate functions and a filter function. You are evaluating the performance of the measures. In which use case will replacing the filter function with the keepfilters function reduce execution time?

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 workspace that uses the default Spark starter pool and runtime version 1,2. You plan to read a CSV file named Sales.raw.csv in a lakehouse, select columns, and save the data as a Delta table to the managed area of the lakehouse. Sales_raw.csv contains 12 columns. You have the following code. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

HOTSPOT You need to resolve the issue with the pricing group classification. How should you complete the

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1. You are creating a new data pipeline. You plan to copy external data to Table1. 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?