Free Microsoft DP-700 Exam Questions

You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 readsdata into a DataFrame from a table named Table1 and applies transformation logic. The data from theDataFrame is then written to a new Delta table named Table2 by using a merge operation.You need to consolidate the underlying Parquet files in Table1.Which command should you run?

What is the role of data encryption in Microsoft Fabric's security strategy?

You have a Fabric workspace that contains an eventstream named EventStreaml. EventStreaml outputs events to a table named Tablel in a lakehouse. The streaming data is souiced from motorway sensors and represents the speed of cars. You need to add a transformation to EventStream1 to average the car speeds. The speeds must be grouped by non-overlapping and contiguous time intervals of one minute. Each event must belong to exactly one window. Which windowing function should you use? 

Which of the following actions can help optimize query performance in large datasets?

Note: This question is part of a series of questions that present the same scenario. Each question in the seriescontains a unique solution that might meet the stated goals. Some question sets might have more than onecorrect 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 questionswill not appear in the review screen.You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. Thetable contains the following columns:BikepointIDStreetNeighbourhoodNo_Bikes No_Empty_DocksTimestampYou need to apply transformation and filter logic to prepare the data for consumption. The solution mustreturn data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be orderedby No_Bikes in ascending order.Solution: You use the following code segment:Does this meet the goal?