DP-700 Exam Questions

You have implemented synchronous mirroring for your data warehouse. You are experiencing performance issues during peak workloads. Which of the following techniques can help improv...

You need to create a pipeline to ingest data from a variety of sources, including SQL Server databases, CSV files, and JSON files. Which of the following pipeline design strategies...

You have a Fabric workspace that contains a warehouse named DW1. DW1 is loaded by using a notebook named Notebook1. You need to identify which version of Delta was used when Notebo...

You have a Fabric workspace that contains a semantic model named Model1. You need to dynamically execute and monitor the refresh progress of Model1. What should you use?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You have a Fabric workspace that contains an eventstream named Eventstream1. Eventstream1 processes data from a thermal sensor by using event stream processing, and then stores the...

You have an Azure event hub. Each event contains the following fields: - BikepointID - Street - Neighbourhood - Latitude - Longitude - No_Bikes - No_Empty_Docks You need to ingest...

Which of the following actions would be most likely to resolve this error ?

You have a data warehouse that is experiencing performance issues during data loading. The data warehouse is using a partitioned table. You have noticed that the data loading proce...

You want to delegate workspace administration tasks to a specific team within your organization. You want to ensure that they have the necessary permissions to manage the workspace...

You need to create a simple ETL pipeline that extracts data from a SQL Server database, performs basic data cleaning, and loads the data into a data warehouse. Which of the followi...

Your organization wants to classify data based on its sensitivity and regulatory requirements. Which of the following methods would be most appropriate for implementing data classi...

You're working with a Microsoft Fabric dataset containing sensitive customer information. You need to ensure that different users can only see their data. Which of the following me...

You're tasked with building a real-time analytics pipeline for a high-volume, low-latency application. The data source is a Kafka topic producing millions of events per second. Whi...

You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse. You need to remove files that are older than sev...

You have a Fabric warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is schedule...

You have a Fabric notebook named Notebook1 that has been executing successfully for the last week. During the last run, Notebook1 executed nine jobs. You need to view the jobs in a...

You need to schedule the population of the medallion layers to meet the technical requirements. What should you do?

You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns. Table name | Column name | Description ---|---|--- SalesOrderDetail...

You need to ensure that processes for the bronze and silver layers run in isolation. How should you configure the Apache Spark settings?

You need to ensure that the authors can see only their respective sales data. How should you complete the statement? To answer, drag the appropriate values the correct targets. Eac...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You have a Fabric workspace named Workspace1 that contains the following items: - A Microsoft Power BI report named Report1 - A Power BI dashboard named Dashboard1 - A semantic mod...

You have a Fabric workspace named Workspace1. Your company acquires GitHub licenses. You need to configure source control for Workspace1 to use GitHub. The solution must follow the...

You have a Fabric workspace named Workspace1. You plan to configure Git integration for Workspace1 by using an Azure DevOps Git repository. An Azure DevOps admin creates the requir...

You have a Fabric workspace that contains a lakehouse and a semantic model named Model1. You use a notebook named Notebook1 to ingest and transform data from an external data sourc...

You have a Fabric workspace that contains a lakehouse named Lakehouse1. You plan to create a data pipeline named Pipeline1 to ingest data into Lakehouse1. You will use a parameter...

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Workspace1 contains the following items: - A Dataflow Gen2 dataflow that copies data from a...

You are building a Fabric notebook named MasterNotebook1 in a workspace. MasterNotebook1 contains the following code. DAG = { "activities": [ { "name": "execute_notebook_1", "path"...

You have a Fabric workspace that contains a data pipeline named Pipeline1 as shown in the exhibit. (Click the Exhibit tab.) What will occur next time Pipeline1 runs?

You need to ensure that WorkspaceA can be configured for source control. Which two actions should you perform? Each correct answer presents part of the solution.

You have two Fabric notebooks named Load_Salesperson and Load_Orders that read data from Parquet files in a lakehouse. Load_Salesperson writes to a Delta table named dim_salesperso...

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse2. A team of data analysts has Viewer role access to Workspace1. You create a table by running...

Hotspot Question You are building a data orchestration pattern by using a Fabric data pipeline named Dynamic Data Copy as shown in the exhibit. (Click the Exhibit tab.)

Dynamic Data Copy does NOT use parametrization. You need to configure the ForEach activity to receive the list of tables to be copied. How should you complete the pipeline expressi...

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named DimCustomers. DimCustomers contains the following columns: - CustomerName...

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named Customer. Customer contains the following data (CustomerID, FirstName, Las...

Which two components should you include in the workflow? Each correct answer presents part of the solution.

You are implementing a medallion architecture in a Fabric lakehouse. You plan to create a dimension table that will contain the following columns: - ID - CustomerCode - CustomerNam...

You have a Fabric workspace named EventStream1. EventStream1 outputs events to a table named Table1 in a lakehouse. The streaming data is sourced from motorway sensors and represen...

You have a Fabric warehouse named DW1 that contains a Type 2 slowly changing dimension (SCD) dimension table named DimCustomer. DimCustomer contains 100 columns and 20 million rows...

You have an Azure SQL database named DB1. In a Fabric workspace, you deploy an eventstream named EventStreamDB1 to stream record changes from DB1 into a lakehouse. You discover tha...

You need to recommend a solution to resolve the MAR1 connectivity issues. The solution must minimize development effort. What should you recommend?

You need to recommend a solution for handling old files. The solution must meet the technical requirements. What should you include in the recommendation?

You have a Fabric warehouse named DW1 that contains four staging tables named ProductCategory, ProductSubcategory, Product, and SalesOrder. ProductCategory, ProductSubcategory, and...

Your company has three newly created data engineering teams named Team1, Team2, and Team3 that plan to use Fabric. The teams have the following personas: - Team1 consists of member...

You plan to process the following three datasets by using Fabric: Dataset1: This dataset will be added to Fabric and will have a unique primary key between the source and the desti...

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Status_Target that has the following columns: - Key - Status - LastModifie...

You are building a data loading pattern by using a Fabric data pipeline. The source is an Azure SQL database that contains 25 tables. The destination is a lakehouse. In a warehouse...

You have a table in a Fabric lakehouse that contains the following data: | SalesOrderNumber | OrderDate | CustomerName | Email | |------------------|------------|----------------|-...