Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-700

Microsoft DP-700 Exam Questions
Implementing Data Engineering Solutions Using Microsoft Fabric (Page 2 )

Updated On: 25-Apr-2026
Page 2 of 16
PDF with 125 Questions
View Related Case Study

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

  1. Disable high concurrency.
  2. Create a custom pool.
  3. Modify the number of executors.
  4. Set the default environment.

Answer(s): B

Explanation:

Isolated Compute
The Isolated Compute option provides more security to Spark compute resources from untrusted services by dedicating the physical compute resource to a single customer. Isolated compute option is best suited for workloads that require a high degree of isolation from other customer's workloads for reasons that include meeting compliance and regulatory requirements. The Isolate Compute option is only available with the XXXLarge (80 vCPU / 504 GB) node size and only available in the following regions. *The isolated compute option can be enabled or disabled after pool creation although the instance might need to be restarted*.
Scenario:

Existing Environment. Data Processing
Litware implements a medallion architecture by using the following three layers: bronze, silver, and gold. The sales data is ingested from the ERP system as Parquet files that land in the Files folder in a lakehouse.
Notebooks are used to transform the files in a Delta table for the bronze and silver layers. The gold layer is in a warehouse that has V-Order disabled.



View Related Case Study

DRAG DROP (Drag and Drop is not supported)
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. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Note: Each correct selection is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: SCHEMABINDING
CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) Creates a user-defined function (UDF) in Azure Synapse Analytics, Analytics Platform System (PDW), or Microsoft Fabric. A user-defined function is a Transact-SQL routine that accepts parameters, performs an action, such as a complex calculation, and returns the result of that action as a value.
In Microsoft Fabric and serverless SQL pools in Azure Synapse Analytics, CREATE FUNCTION can create inline table-value functions but not scalar functions. User-defined table-valued functions (TVFs) return a table data type.
Inline table-valued function syntax
-- Transact-SQL Inline Table-Valued Function Syntax
-- Preview in dedicated SQL pools in Azure Synapse Analytics -- Available in the serverless SQL pools in Azure Synapse Analytics and Microsoft Fabric CREATE FUNCTION [ schema_name. ] function_name
( [ { @parameter_name [ AS ] parameter_data_type
[ = default ] }
[ ,...n ]
]
)
RETURNS TABLE
[ WITH SCHEMABINDING ]
[ AS ]
RETURN [ ( ] select_stmt [ ) ]
[ ; ]
--
SCHEMABINDING
Specifies that the function is bound to the database objects that it references.
When SCHEMABINDING is specified, the base objects cannot be modified in a way that would affect the function definition. The function definition itself must first be modified or dropped to remove dependencies on the object that is to be modified.
Box 2: USER_NAME()
USER_NAME (Transact-SQL)
Returns a database user name from a specified identification number, or the current user name.
Box 3: AuthorSales
We specify the table name, table_schema_name.table_name below.
.
Scenario:
Litware also manages an online advertising business for the authors it represents.

Existing Environment. Sales Data
A table named AuthorSales stores the sales data that relates to each author. The table contains a column named AuthorEmail. Authors authenticate to a guest Fabric tenant by using their email address.
Note: CREATE SECURITY POLICY (Transact-SQL)
Create a security policy
The following syntax creates a security policy with a filter predicate for the dbo.Customer table, and leaves the security policy disabled.
SQL
CREATE SECURITY POLICY [FederatedSecurityPolicy]
ADD FILTER PREDICATE [rls].[fn_securitypredicate]([CustomerId]) ON [dbo].[Customer];
--
table_schema_name.table_name
Is the target table to which the security predicate will be applied. Multiple disabled security policies can target a single table for a particular DML operation, but only one can be enabled at any given time.
Full Syntax:
CREATE SECURITY POLICY [schema_name. ] security_policy_name
{ ADD [ FILTER | BLOCK ] } PREDICATE tvf_schema_name.security_predicate_function_name ( { column_name | expression } [ , ...n] ) ON table_schema_name. table_name [ <block_dml_operation> ] , [ , ...n]
[ WITH ( STATE = { ON | OFF } [,] [ SCHEMABINDING = { ON | OFF } ] ) ] [ NOT FOR REPLICATION ]
[;]



View Related Case Study

You need to ensure that the data analysts can access the gold layer lakehouse.
What should you do?

  1. Add the DataAnalyst group to the Viewer role for Workspace
  2. Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.
  3. Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.
  4. Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.

Answer(s): C

Explanation:

Data Analysts' Access Requirements must only have read access to the Delta tables in the gold layer and not have access to the bronze and silver layers.
The gold layer data is typically queried via SQL Endpoints. Granting the Read all SQL Endpoint data permission allows data analysts to query the data using familiar SQL-based tools while restricting access to the underlying files.



View Related Case Study

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.
Note: Each correct selection is worth one point.

  1. From Tenant setting, set Users can synchronize workspace items with their Git repositories to Enabled.
  2. From Tenant setting, set Users can sync workspace items with GitHub repositories to Enabled.
  3. Configure WorkspaceA to use a Premium Per User (PPU) license.
  4. Assign WorkspaceA to Cap1.

Answer(s): A,D

Explanation:

A F64 capacity is a Microsoft Fabric Capacity (Pay-as-you-go or Reservation).
Note: Microsoft Fabric, Get started with Git integration
Prerequisites
To integrate Git with your Microsoft Fabric workspace, you need to set up the following prerequisites for both Fabric and Git.
Fabric prerequisites
To access the Git integration feature, you need a Fabric capacity. A Fabric capacity is required to use all supported Fabric items [D]. If you don't have one yet, sign up for a free trial. Customers that already have a Power BI Premium capacity, can use that capacity, but keep in mind that certain Power BI SKUs only support Power BI items.
In addition, the following tenant switches must be enabled from the Admin portal:
* Users can create Fabric items
*-> Users can synchronize workspace items with their Git repositories [A, not B] For GitHub users only: Users can synchronize workspace items with GitHub repositories Scenario:

Existing Environment. Fabric
Contoso has an F64 capacity named Cap1 [D]. All Fabric users are allowed to create items.
Contoso has two workspaces named WorkspaceA and WorkspaceB that currently use Pro license mode.

Requirements. Planned Changes
Contoso plans to use Azure Repos for source control in Fabric.

Requirements. Technical Requirements
Items that relate to data ingestion must meet the following requirements:
*-> The items must be source controlled alongside other workspace items.

Requirements. Data Security
Security in Fabric must meet the following requirements:
*-> The data engineers must be able to commit changes to source control in WorkspaceA.



You have a Fabric workspace.
You have semi-structured data.
You need to read the data by using T-SQL, KQL, and Apache Spark. The data will only be written by using Spark.
What should you use to store the data?

  1. a lakehouse
  2. an eventhouse
  3. a datamart
  4. a warehouse

Answer(s): A

Explanation:

A lakehouse is the best option for storing semi-structured data when you need to read it using T-SQL, KQL, and Apache Spark. A lakehouse combines the flexibility of a data lake (which can handle semi-structured and unstructured data) with the performance features of a data warehouse. It allows data to be written using Apache Spark and can be queried using different technologies such as T-SQL (for SQL-based querying), KQL (Kusto Query Language for querying), and Apache Spark (for distributed processing). This solution is ideal when dealing with semi-structured data and requiring a versatile querying approach.



You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on- premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

  1. a Dataflow Gen1 dataflow
  2. a data pipeline
  3. a KQL queryset
  4. a notebook

Answer(s): B

Explanation:

To copy data from an on-premises Microsoft SQL Server database (Database1) to a warehouse (Warehouse1) in Microsoft Fabric, the best option is to use a data pipeline. A data pipeline in Fabric allows for the orchestration of data movement, from source to destination, using connectors, transformations, and scheduled workflows. Since the data is being transferred from an on-premises database and requires the use of a data gateway, a data pipeline provides the appropriate framework to facilitate this data movement efficiently and reliably.



You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on- premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

  1. an Apache Spark job definition
  2. a data pipeline
  3. a Dataflow Gen1 dataflow
  4. an eventstream

Answer(s): B

Explanation:

To copy data from an on-premises Microsoft SQL Server database (Database1) to a warehouse (Warehouse1) in Fabric, a data pipeline is the most appropriate tool. A data pipeline in Fabric is designed to move data between various data sources and destinations, including on-premises databases like SQL Server, and cloud- based storage like Fabric warehouses. The data pipeline can handle the connection through an on-premises data gateway, which is required to access on-premises data. This solution facilitates the orchestration of data movement and transformations if needed.



You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?

  1. Change the MD5 hash to SHA256.
  2. Increase the capacity.
  3. Enable V-Order.
  4. Modify the surrogate keys to use a different data type.
  5. Create views.

Answer(s): B

Explanation:

Correct:
* Increase the capacity.
We need to upgrade the capacity.
Direct Lake in Fabric F32 Capacity supports tables up to 300 million rows. F64 can handle 500 million rows.
Incorrect:
* Change the MD5 hash to SHA256.
* Create views.
* Disable V-Order on the warehouse.
* Enable V-Order.
* Modify the surrogate keys to use a different data type.



Viewing page 2 of 16
Viewing questions 6 - 10 out of 125 questions
Share your experience with other


DP-700 Exam Discussions & Posts

What the DP-700 Exam Tests and How to Pass It

The DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric certification is designed for data engineers who are responsible for designing, implementing, and managing data engineering solutions within the Microsoft Fabric ecosystem. Professionals who pursue this Microsoft certification typically work in roles that require them to integrate, transform, and consolidate data from various sources into a unified analytics platform. Employers look for this credential because it validates a candidate's ability to handle the end-to-end lifecycle of data engineering tasks, ensuring that data is reliable, secure, and ready for downstream analytics or machine learning applications. By passing this exam, candidates demonstrate that they possess the technical proficiency required to maintain high-performance data pipelines and optimize storage solutions in a cloud-based environment. This certification is a key benchmark for organizations that rely on Microsoft Fabric to drive their data-driven decision-making processes.

What the DP-700 Exam Covers

The exam evaluates your ability to implement and manage an analytics solution, which involves configuring the environment and ensuring that data governance and security standards are met throughout the lifecycle. Candidates must demonstrate proficiency in how to ingest and transform data, a core competency that requires understanding various data integration patterns, pipeline orchestration, and the application of transformations to raw data to make it usable for business intelligence. Furthermore, the exam tests your skills in how to monitor and optimize an analytics solution, ensuring that data engineering workloads run efficiently and cost-effectively within the Microsoft Fabric platform. Our practice questions are structured to mirror these functional areas, allowing you to test your knowledge across the entire spectrum of data engineering tasks you will encounter on the job. By engaging with these practice questions, you can identify specific areas where your technical understanding may need reinforcement before sitting for the actual certification exam.

The most technically demanding aspect of the DP-700 exam often involves the intricacies of data transformation and pipeline optimization, as these tasks require a deep understanding of how data flows through the Fabric architecture. Candidates are frequently challenged by scenarios that require them to choose the most efficient transformation method or troubleshoot performance bottlenecks in complex data pipelines. Success in this area requires more than just theoretical knowledge; it demands an applied understanding of how different Fabric components interact under load. You must be prepared to analyze architectural requirements and apply the correct engineering principles to ensure data integrity and system performance, which is why consistent practice with scenario-based questions is essential for thorough exam preparation.

Are These Real DP-700 Exam Questions?

The practice questions available on our platform are sourced and verified by the community, consisting of IT professionals and recent test-takers who have sat for the actual Microsoft certification exam. While we do not provide leaked or confidential content, our questions reflect what appears on the real exam because they are sourced from the community, ensuring that the concepts, question styles, and technical scenarios align with the current exam objectives. If you've been searching for DP-700 exam dumps or braindump files, our community-verified practice questions offer something more valuable, each question is verified and explained by IT professionals who recently passed the exam. This approach ensures that you are studying relevant material that helps you understand the underlying technology rather than simply memorizing patterns that may not appear on the test.

Community verification works through a collaborative process where users actively discuss answer choices, flag potentially incorrect information, and share context from their recent exam experiences. When a question is flagged, it is reviewed by other members of the community to ensure accuracy and clarity, creating a self-correcting system that improves the quality of the study material over time. This peer-review mechanism is what makes our practice questions a reliable resource for your exam prep, as it provides multiple perspectives on how to approach complex data engineering problems. By participating in these discussions, you gain insights into the reasoning behind correct answers, which is far more effective for long-term retention than relying on static, unverified sources.

How to Prepare for the DP-700 Exam

Effective exam preparation for the DP-700 requires a combination of hands-on experience and a solid grasp of the official Microsoft documentation. You should prioritize building a study schedule that allows you to experiment with Microsoft Fabric in a sandbox or development environment, as practical application is the best way to internalize the concepts tested on the exam. Every practice question includes a free AI Tutor explanation that breaks down the reasoning behind the correct answer, so you understand the concept, not just the answer. This AI Tutor serves as an on-demand resource to clarify complex topics, helping you bridge the gap between reading documentation and applying that knowledge to solve real-world data engineering challenges.

A common mistake candidates make is relying solely on rote memorization of facts, which often leads to failure when they encounter scenario-based questions that require critical thinking. The DP-700 exam is designed to test your ability to apply knowledge in specific contexts, meaning you must understand the "why" and "how" behind each data engineering solution, not just the definitions. To avoid this, focus on understanding the architectural trade-offs involved in different data ingestion and transformation strategies. Additionally, many candidates struggle with time management during the certification exam; practicing with timed sets of questions can help you develop the pace necessary to complete the exam without rushing through complex scenarios.

What to Expect on Exam Day

On the day of your exam, you should expect a format that includes a variety of question types, such as multiple-choice, scenario-based questions, and potentially drag-and-drop or ordering tasks that test your procedural knowledge. Microsoft certification exams are typically administered via a secure testing environment, either at a physical Pearson VUE testing center or through an online proctored session. You will be given a set amount of time to complete the exam, and it is important to read each scenario carefully, as the details provided in the prompt are crucial for selecting the correct answer. The exam is designed to be rigorous, ensuring that those who pass have a genuine, verified level of competence in implementing data engineering solutions using Microsoft Fabric.

Who Should Use These DP-700 Practice Questions

These practice questions are intended for data engineers, data architects, and IT professionals who are looking to validate their skills in the Microsoft Fabric ecosystem. Ideally, candidates should have some experience working with data integration, transformation, and analytics solutions before attempting this certification exam. Whether you are looking to advance your career or simply formalize your knowledge, these resources are designed to support your exam preparation journey by providing a structured way to test your readiness. Passing this certification exam is a significant milestone that demonstrates your ability to manage complex data engineering workloads, making you a more competitive candidate in the job market.

To get the most out of these practice questions, do not simply read the answer and move on; instead, engage deeply with the AI Tutor explanation and review the community discussions for each item. If you find yourself consistently getting questions wrong in a specific topic area, flag those questions and revisit them after reviewing the relevant official documentation. This iterative process of testing, reviewing, and re-testing is the most reliable way to build the confidence needed for the actual exam. Browse the questions above and use the community discussions and AI Tutor to build real exam confidence.

Updated on: 27 April, 2026

AI Tutor AI Tutor 👋 I’m here to help!