DP-700 Exam Questions

You have a Fabric workspace that contains an eventhouse named Eventhouse1. In Eventhouse1, you plan to create a table named DeviceStreamData in a KQL database. The table will conta...

Which three code segments should you run in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correc...

You have a KQL database that contains a table named Readings. You need to build a KQL query to compare the MeterReading value of each row to the previous row based on the Timestamp...

You need to recommend a Fabric streaming solution that will use the sources shown in the following table. Source1: Message size: 10 MB, Description: Contains semi-structured data t...

When a new book cover image arrives in the Files folder, process the image as soon as possible. What should you do to optimize the query experience for the business users?

You have a Fabric workspace that contains a warehouse named Warehouse1. While monitoring Warehouse1, you discover that query performance has degraded during the last 60 minutes. Yo...

You have a Fabric workspace that contains a semantic model named Model1. You need to monitor the refresh history of Model1 and visualize the refresh history in a chart. What should...

You have a Fabric workspace that contains a write-intensive warehouse named DW1. DW1 stores staging tables that are used to load a dimensional model. The tables are often read once...

Which of the following statements is true regarding the use of starter pools in Microsoft Fabric's Spark workspace settings?

Your organization is tasked with transforming a dataset containing semi-structured JSON data into a structured tabular format. The workflow includes: - Parsing the nested JSON data...

An e-commerce platform processes a high volume of order events through an event streaming system. Recently, the analytics dashboard began showing incomplete and inconsistent data....

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Table W. You analyze Table W and discover that Table W contains 2,00...

You are working in a Fabric workspace and want to certify your item or designate it as master data. However, you do not have the authorization to perform this action directly. What...

In Microsoft Fabric, which of the following statements accurately describes the behavior of domain workspace settings? (Select 2)

You manage a semantic model in Microsoft Fabric. Row-level security (RLS) has been configured with two roles: FinanceTeam and SalesTeam. The following roles have been assigned perm...

You are working in a Microsoft Fabric data environment that includes a data warehouse named Warehouse1. This warehouse receives daily data updates via data pipeline and stored proc...

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1. You plan to deploy Warehouse 1 to a new workspace named Workspace2. As part of the deployme...

You need to ensure that the data engineers are notified if any step in populating the lakehouses fails. The solution must meet the technical requirements and minimize development e...

In the Development workspace, you build a new feature named Feature1. You need to deploy Feature1 to the Test workspace. The solution must ensure that only a pipeline is deployed....

You have Fabric lakehouse that contains a table named Table1. Table1 stores data in the following format. You have a notebook that contains the following code segment. df = df.with...

You have the development groups shown in the following table. Name | Skillset --- | --- Group1 | Azure Stream Analytics with Azure Event Hubs Group2 | Microsoft Power BI Group3 | R...

You need to have a Microsoft Power Apps app named App1 that has data stored in Microsoft Dataverse. You need to access the App1 data by using Fabric. What should you use?

You need to modify the DAG definition to meet the following requirements: - Ensure that notebook_01 and notebook_02 run in parallel. - Ensure that notebook_03 only runs after the e...

You need to add a new set of data to the bronze layer. This data is in an Azure Data Lake Storage Gen2 account and consists of CSV files. You need to ensure that this data can be i...

You need to implement a solution to monitor the performance of your Fabric workspaces and identify bottlenecks. You want to visualize key metrics like query execution times and dat...

You are designing a data solution in Microsoft Fabric that will process large volumes of streaming data from IoT devices. The data needs to be ingested, transformed, and made avail...

You need to create a secure way for external business partners to access specific reports in your Fabric workspace, without giving them access to the underlying data or other works...