Free Microsoft DP-700 Exam Questions

Which of the following is a feature of Azure Data Lake Storage Gen2 in Microsoft Fabric?

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?

Which of the following metrics should be monitored to assess query performance?

You have an Azure event hub. Each event contains the following fields:BikepointIDStreetNeighbourhoodLatitudeLongitudeNo_BikesNo_Empty_DocksYou need to ingest the events. The solution must only retain events that have a Neighbourhood value ofChelsea, and then store the retained events in a Fabric lakehouse.What should you use?

Which of the following transformations can be performed using Azure Data Factory?