Free Microsoft DP-700 Exam Questions

Which of the following best defines the role of data warehouses in the context of analytics solutions?

Which of the following services can be used to automate tasks such as triggering data pipelines in response to an HTTP request?

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?

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 services can be used to automate tasks such as triggering data pipelines in response to an HTTP request?