ExamDumpster

Free DP-700 sample questions

Start with these free DP-700 sample questions, which include answers and explanations. They cover loading patterns, streaming data and performance tuning in Fabric. Work through them to see which data engineering skills need more work.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose one

A data engineer has configured a Fabric deployment pipeline with Development, Test, and Production stages. After deploying changes from Test to Production, they notice that the connection details for a Lakehouse shortcut, which should point to a different storage account in Production, have not been updated. They need to ensure that connection details are automatically updated during deployment. What must be configured in the deployment pipeline?

Question 2Choose one

You are designing a solution to ingest data from an Amazon S3 bucket into a Fabric Lakehouse. The data consists of historical logs stored in Parquet format, totaling over 5 TB. The key requirements are to minimize data duplication and avoid cross-cloud data transfer costs for exploratory analysis, while still allowing data to be transformed and loaded into managed Delta tables for production reporting. Which Fabric feature should you use as the primary mechanism to access the S3 data?

Question 3Choose one

A data pipeline that loads data into a Fabric Warehouse fails intermittently. The pipeline monitoring view shows that the 'Copy Data' activity is failing with the error message: `Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.` The source is an on-premises SQL Server accessed via a data gateway. What is the most likely cause of this issue and the best first step to resolve it?

Question 4Choose one

You are implementing a medallion architecture in a Fabric Lakehouse. You need to perform the `VACUUM` operation on your Delta tables to remove old, unreferenced files and manage storage costs. According to Microsoft's recommended best practices, how should you typically execute the `VACUUM` command?

Question 5Choose 2

You are using Spark Structured Streaming in a Fabric notebook to process a continuous stream of JSON messages. The goal is to write the output to a Delta table while handling late-arriving data. You need to ensure that events arriving up to 1 hour late are included in the correct windowed aggregation. Which combination of Structured Streaming features should you use? (Select TWO)

Question 6Choose one

A team is building a dimensional model in a Fabric Warehouse. They have created a `DimDate` dimension table. They need to create a relationship between the `FactSales` table's `OrderDate` column and the `DimDate` table's `Date` column. What is the correct T-SQL syntax to define this foreign key relationship in the Fabric Warehouse?

Question 7Choose one

True or False: In Microsoft Fabric, both a Lakehouse and a Warehouse can be queried using the same T-SQL endpoint, but only the Warehouse enforces transactional ACID compliance through its SQL engine.

Question 8Choose one

You are managing a Fabric workspace where multiple data engineers are developing notebooks concurrently. To improve resource utilization and reduce session startup times, you want to enable a feature that allows multiple notebooks from the same user to share a single Spark session. Which workspace setting must be enabled to achieve this?

Question 9Choose one

A data engineer needs to apply sensitivity labels to Fabric items to classify data according to the company's data governance policy. Where must these sensitivity labels be defined before they can be applied within the Fabric workspace?

Question 10Choose one

You are monitoring the refresh history of a Power BI semantic model that is in Direct Lake mode connected to a Fabric Lakehouse. You notice several refresh failures with the error 'Direct Lake objects are out of sync with the lakehouse'. What is the most effective way to resolve this issue and ensure the semantic model reflects the latest data?

10 more free samples are waiting

Create a free account to unlock the whole DP-700 sample bank, or get full access to all 302 practice questions in the simulator.

Create account