Be able to configure Dataflows Gen2, pipelines, and Copy activity end to end: pick the right gateway or integration runtime, choose Delta or Parquet for Lakehouse, and flatten nested JSON. The single most important thing is matching the source connector and destination to the required Fabric artifact and runtime.
Start practicing
Ingest and Transform Data — choose a session length
Free · No account required
Domain overview
This domain covers getting data into Fabric and reshaping it: Dataflows Gen2, Data Factory pipelines, Copy activity, and Lakehouse/Warehouse loading. Questions present exhibits, error messages, or scenario constraints and ask you to pick the correct connector, integration runtime, file format, or transformation approach. Expect both configuration decisions and troubleshooting based on concrete symptoms.
Exam objectives
Publishing Dataflow Gen2 outputs to a Fabric Warehouse and resolving destination errors
Choosing on-premises data gateway versus VNet gateway integration runtime for throughput
Selecting Parquet or Delta Lake format for Lakehouse performance in Fabric
Flattening nested JSON arrays with Copy activity or Dataflow transformations into Lakehouse tables
Assuming a Dataflow Gen2 can write directly to a Warehouse without the required destination support or permissions, causing publish failure.
Picking the default cloud integration runtime for on-premises SQL Server sources instead of installing and selecting a gateway.
Leaving nested JSON arrays unflattened, so each element is not written as its own row in the Lakehouse table.
Click any question to see the full explanation and answer options, or start a focused practice session above.
You are designing a Fabric pipeline to copy data from an on-premises SQL Server to a OneLake Lakehouse. Which integration runtime configuration ensures the highest throughput for large datasets?
2You have a large Delta table that is frequently queried. You notice that queries are slow due to small file overhead. Which command should you run to optimize this table?
3You are configuring a Fabric Pipeline. Which TWO activities can be used to perform conditional logic within your data ingestion workflow?
4You need to ingest data from an API into a Fabric Lakehouse. The API requires a token-based authentication refreshed every hour. What is the most efficient way to handle this?
5You are designing a data lakehouse architecture. Which file format is recommended for optimal performance in Fabric?
6When ingesting data from an external source, what is the best practice for handling sensitive data?
7Refer to the exhibit. You are using Structured Streaming to ingest data into a Delta table. Why is the checkpoint path required?
8Which Fabric feature allows you to monitor the status and history of your data pipeline runs?
9You are processing a large dataset in a Notebook and encounter frequent 'Shuffle' operations that slow down the job. What is the most likely cause?
10You are configuring a medallion architecture in Microsoft Fabric using Lakehouse Delta tables. You need to implement an incremental data load pattern from a bronze table to a silver table using a PySpark notebook. Which TWO actions must you perform to ensure idempotency and high performance? Choose exactly two.
11You are designing a data pipeline in Microsoft Fabric using Data Factory. You need to ingest data from an on-premises SQL Server database into a Lakehouse. Which integration component must be deployed to facilitate secure connectivity between the on-premises network and Microsoft Fabric?
12You are developing a Notebook in Microsoft Fabric to process high-volume sensor data. You need to optimize performance using Delta Lake features. Which TWO actions should you perform? (Choose two)
13You are performing a large-scale data migration into a Fabric Lakehouse using a Spark Notebook. You notice that the job is failing with an 'Out of Memory' error. What is the most effective way to address this while utilizing PySpark?
14You need to automate the ingestion of files from an Azure Blob Storage container into a Fabric Lakehouse. Which THREE components are required to build this automated pipeline? (Choose three)
15You are configuring a Fabric pipeline to perform incremental loads from a source system. Which approach is considered the best practice to track changes efficiently?
16Refer to the exhibit. Given the retry policy configuration, what happens if the source SQL database is temporarily unavailable during the first attempt?
17You are designing a data transformation layer using Spark in Microsoft Fabric. Which THREE of the following are primary benefits of using Delta Lake format over traditional Parquet files? (Choose three)
18You are monitoring a Fabric pipeline. You need to identify which activity failed within the pipeline execution. Which tool should you use?
19Refer to the exhibit. You are loading this file into a Lakehouse. You notice that the column headers contain special characters, and the data is failing to load correctly. What should you do?
20You are building a pipeline and need to ensure that a downstream activity only runs if a previous activity succeeds. Which pipeline feature should you use?
21You need to access data from an external Azure Data Lake Storage (ADLS) Gen2 account in a Fabric Lakehouse without duplicating the physical data. Which feature should you use?
22You are building a Dataflow Gen2 to ingest a 50 GB CSV file from an Azure Storage account into a Fabric Lakehouse. You want to ensure the ingestion uses the 'Fast Copy' feature. What must you do?
23Your organization wants to implement near real-time data ingestion from an Azure SQL Database into Fabric for reporting. You must minimize the impact on the source database's performance and avoid manual pipeline scheduling. Which solution should you implement?
24You have a Lakehouse with several Delta tables. You need to provide a SQL-based interface for data analysts to query this data using their existing SQL tools, but you want to ensure they do not accidentally modify the underlying files. What should you use?
25When writing data to a Lakehouse table using a Spark Notebook in Microsoft Fabric, which optimization is enabled by default to ensure maximum compatibility and performance across all Fabric engines?
26You need to ingest data from an Azure SQL Database that is protected by a firewall and does not allow public network access. Which Fabric feature should you use to establish a secure connection without opening the firewall to all Azure services?
27You need to ingest data from an on-premises SQL Server database into a Fabric Lakehouse. What must be installed and configured on a local server to facilitate this connection?
28You are configuring a Copy Activity in Fabric Data Factory to ingest data from an external REST API. Which TWO configuration settings are required to ensure data is handled correctly? (Choose two)
29You are using Dataflow Gen2 to ingest data from multiple sources. You need to perform a complex transformation that involves merging data from a SQL database and a flat file based on a common key. Which step should you take to achieve this efficiently?
30Which file format should you choose for a Lakehouse to ensure the best support for ACID transactions and high-performance analytical queries?
31Which Fabric feature allows you to orchestrate complex data ingestion and transformation workflows using a drag-and-drop interface?
32You are monitoring a Data Factory pipeline. What is the best way to be notified when a pipeline fails during an execution?
33You are optimizing a Spark job in Fabric. Which TWO of the following techniques will help reduce the execution time? (Choose two)
34Which Fabric tool would you use to perform a visual, low-code data transformation that directly results in a clean table in your Lakehouse?
35You are optimizing the ingestion of a large dataset into a Microsoft Fabric Lakehouse using a Spark Notebook. To ensure optimal query performance for downstream consumers, you want to apply the V-Order optimization and partition the data. Which TWO actions should you take to achieve this?
36A data engineer needs to provide access to data stored in an external Azure Data Lake Storage (ADLS) Gen2 account without moving the data into the Fabric Lakehouse. Which feature of Microsoft Fabric should be used?
37You are building a Medallion architecture in Fabric. You have ingested raw CSV files into the 'Files' section of your Bronze Lakehouse. You now need to transform this data and load it into a Delta table in the Silver Lakehouse. Which method provides the best performance and scalability for this transformation?
38You are configuring a Data Factory Pipeline to perform an incremental load from an Azure SQL Database to a Fabric Warehouse. Which THREE components or features are essential for implementing a watermark-based incremental load? (Choose THREE)
39Refer to the exhibit. You are attempting to publish a Dataflow Gen2 that loads data into a Fabric Warehouse. Based on the error message, what action must you take to successfully publish the dataflow?
40You are ingesting thousands of small JSON files into a Fabric Lakehouse. You notice that query performance on the resulting Delta table is very poor. Which ingestion strategy should you implement to resolve the 'small files problem'?
41You are designing a data pipeline in Microsoft Fabric to ingest incremental data from an on-premises SQL Server. You need to ensure that only records modified since the last pipeline run are ingested. Which approach should you implement to maintain optimal performance and minimal data redundancy?
42You are designing a Fabric Data Factory pipeline that ingests semi-structured JSON from an Azure Blob Storage container into a Lakehouse. The source files are large (multi-GB) and each file contains a JSON array. You need the pipeline to flatten nested arrays into separate rows during ingestion without writing custom Spark code. Which activity should you use?
43You are building a Fabric Data Factory pipeline that ingests CSV files dropped into an Azure Data Lake Storage Gen2 container every night. Each file must be transformed before landing in a Lakehouse, and the team wants to reuse the same transformation logic across several pipelines without duplicating notebook code. Which approach best meets these requirements?
44You are building a Fabric Data Factory pipeline that ingests JSON files from an Azure Blob Storage container into a Lakehouse. The JSON files use a nested structure where each record contains an array of line items. You need to flatten this array so that each line item becomes a separate row in the destination table. Which transformation should you add to the pipeline?
45You are ingesting a high-volume stream of JSON events into a Fabric Lakehouse using Spark Structured Streaming. The events arrive out of order, and late-arriving records must still be merged into the correct hourly aggregate. You also need exactly-once processing across restarts. Which combination of features should you implement?
46You are using a Fabric Data Factory pipeline to copy data from an on-premises Oracle database to a Lakehouse. The pipeline must run on a schedule. You have already installed the on-premises data gateway. What should you configure next to ensure the pipeline can connect to the Oracle database?
47You are using a Fabric Spark notebook to ingest a large CSV file from OneLake into a Lakehouse. The file contains a column with mixed date formats such as '2023-01-01' and '01/02/2023'. You need to ensure that the ingestion fails fast if any row cannot be parsed into a valid timestamp. Which PySpark read option should you use?
48You are designing a Fabric Data Factory pipeline that ingests data from a REST API. The API returns data in JSON format and requires pagination using a 'nextLink' property in the response. You need to configure the pipeline to automatically follow the pagination and retrieve all pages. What should you do?
49You are building a Fabric Data Factory pipeline that must copy a 40 GB CSV file from an Azure Blob Storage container into a Fabric Lakehouse Files area every night. The copy must finish within a 30-minute window. Testing shows the default copy throughput is too slow. You need to increase parallelism without changing the source file. What should you configure?
50You are using a Spark notebook in Microsoft Fabric to transform data in a Lakehouse. You need to optimize a large Delta table for frequent queries that filter on a high-cardinality column. Which action should you take to improve query performance?
51You are building a Fabric Data Factory pipeline that must ingest CSV files from an Azure Blob Storage container into a Lakehouse. The files arrive with unpredictable names (for example, sales_20240101.csv, sales_20240102.csv). You need the pipeline to dynamically discover and process each file without manual intervention. Which activity should you use to retrieve the list of files?
52You are building a Fabric Data Factory pipeline that ingests CSV files from an Azure Blob Storage container into a Lakehouse. The files arrive every 15 minutes and each file contains a header row. You need to ensure that the header row is not loaded as data and that the pipeline automatically detects the column names. Which Copy Activity configuration should you use?
53You are implementing a Fabric Data Factory pipeline that copies data from an Azure SQL Database into a Lakehouse. The source table has a last-modified column, and you must load only rows changed since the previous successful run. You also need the pipeline to resume from the correct point if it fails partway. (Choose two.)
54You are building a Fabric Data Factory pipeline to ingest CSV files that arrive hourly in an Azure Data Lake Storage Gen2 account. Each file has a timestamp embedded in its name, and you must process only files that have not been processed before. You want to avoid reprocessing duplicates and keep the solution minimal. What should you use?
55You are orchestrating a Fabric Data Factory pipeline that runs a Notebook activity to transform data, then loads the result into a Warehouse. The transformation must not run if the upstream source file is empty, and the pipeline must send an alert when it is skipped. Which configuration should you implement?
56You are building a Fabric Data Factory pipeline that ingests CSV files from an Azure Blob Storage container into a Lakehouse. The files arrive with varying schemas, and some contain corrupted rows. You need the pipeline to continue processing valid rows while logging the corrupted ones for later review. Which Data Factory activity should you use?
57You are using a Dataflow Gen2 in Microsoft Fabric to transform data from an on-premises SQL Server to a Lakehouse. You need to ensure that the dataflow can connect to the on-premises database. What should you configure?
58You are designing a Fabric Data Factory pipeline that must ingest only new and changed rows from an on-premises Oracle database into a Lakehouse on a daily schedule. The source table has a LastModifiedUtc column that is updated on every insert and update, but rows are never deleted. You need the pipeline to be resilient to pipeline failures and avoid reprocessing rows that were already loaded. What should you configure in the Copy Activity?
59You are ingesting CSV files into a Fabric Lakehouse using a Dataflow Gen2. The files contain columns with mixed data types, and you need to ensure that the output table in the Lakehouse has explicit data types and is optimized for analytical queries. What should you do in the Dataflow Gen2 before writing to the Lakehouse?
60You are orchestrating a Fabric Data Factory pipeline that calls a Dataflow Gen2 to transform sales data, then loads the result into a Warehouse. The dataflow occasionally fails due to a transient capacity issue. You need the pipeline to retry only the dataflow activity up to three times with a 60-second interval, without re-running the rest of the pipeline. What should you configure?
61You are using a Fabric Data Pipeline with a Copy activity to ingest data from an Azure Blob Storage container into a Lakehouse. The source files are in JSON format and contain nested arrays. You need to flatten the nested arrays into separate rows during ingestion. Which transformation should you use?
62You are using a Fabric Spark notebook to ingest streaming data from an Eventstream into a Lakehouse Delta table. The stream occasionally sends late-arriving data that must be merged into the target table based on a composite key. You need to ensure that the merge operation is idempotent and handles duplicates. Which approach should you use?
63You are implementing a Fabric Data Factory pipeline that copies data from an Azure SQL Database to a Lakehouse. The source table has a column with a data type that is not supported by the Lakehouse Delta format. You need to ensure the data is copied correctly without errors. What should you do in the Copy activity?
64You are designing a Fabric Data Factory pipeline to incrementally load new and changed rows from an Azure SQL Database into a Fabric Lakehouse table. The source table has a LastModified column that is updated on every change, but rows can be deleted physically. You need to capture inserts, updates, and deletes. Which TWO components should you include in the solution? (Choose two.)
65You are creating a Data Factory pipeline in Microsoft Fabric to copy data from an Azure SQL Database to a Lakehouse. You need to ensure that the copy operation only transfers rows that have been modified since the last successful run. Which feature should you configure?
66You are using a Spark notebook in Microsoft Fabric to transform data from a Lakehouse bronze table into a silver table. The bronze table is continuously updated with new records, and you need to apply updates and inserts to the silver table based on a primary key. The silver table must reflect the latest state and support efficient queries. Which Delta Lake operation should you use?
67You are using a Fabric Spark notebook to ingest JSON files from a Lakehouse Files folder into a Delta table. The JSON is semi-structured, with nested arrays and occasional missing fields. Downstream queries need to access nested elements as columns, and the schema must be stable across runs even when new fields appear. What should you use?
68You are designing a Fabric Data Factory pipeline that ingests data from an on-premises Oracle database into a Lakehouse. The pipeline must run daily and minimize data transfer by loading only new or changed records. You need to configure the pipeline to use a watermark column. Which two components are required to implement this incremental load pattern? (Choose two.)
69You are using a Fabric Spark Notebook to ingest data from a Parquet file into a Lakehouse Delta table. You need to ensure that the ingestion process is optimized for performance and handles schema evolution. Which TWO actions should you perform? (Choose two.)
70You need to ingest data from an Azure SQL Database into a Fabric Lakehouse. The data volume is large, and you want to minimize the time spent on data movement. You also want to avoid writing custom code. Which Fabric Data Factory activity should you use?
71You are building a Fabric Data Factory pipeline that must copy data from an Azure SQL Database to a Fabric Lakehouse. The pipeline will run hourly, and the source table is large. You need to minimize the impact on the source database and ensure the copy performs well. Which two actions should you take? (Choose two.)
72You are using a Fabric Spark notebook to ingest streaming data from an event hub into a Lakehouse Delta table. The ingestion must handle late-arriving data and ensure exactly-once processing semantics. You configure a Structured Streaming query with a checkpoint location. Which additional setting should you configure to handle late data?
73You are building a Fabric Data Factory pipeline that ingests a large volume of files from an Azure Data Lake Storage Gen2 account into a Lakehouse. The source files have varying schemas, and you need to preserve the original files while also creating a queryable Delta table. Which activity should you use to copy the files without schema enforcement, and then use a separate Spark notebook to transform and write the Delta table?
74You need to ingest data from a REST API that returns JSON responses into a Fabric Lakehouse. The API returns data in pages, and each response includes a 'nextPageToken' field that must be passed as a query parameter to retrieve the next page. You want to use a Fabric Data Factory pipeline with a Copy Activity. What should you configure to handle pagination?
75You are using a Fabric Data Factory pipeline to copy data from an on-premises Oracle database to a Fabric Lakehouse. The pipeline must run daily and handle incremental changes based on a timestamp column. You have installed and configured the on-premises data gateway. Which component should you configure to extract only the rows modified since the last successful run?
76You are using a Fabric Data Pipeline to copy data from an Azure SQL Database to a Fabric Lakehouse. The source table contains a column with a data type that is not supported by the Lakehouse Delta table. You need to ensure the copy succeeds without data loss. What should you do?
77You are building a Fabric Data Factory pipeline that ingests only new and changed rows from an Azure SQL Database into a Fabric Lakehouse on a nightly schedule. The source table has a LastModifiedUtc column that is reliably updated on every insert and update. You need the pipeline to read only rows changed since the previous successful run, and the watermark must persist across pipeline runs without manual intervention. Which approach should you use?
78You are using a Fabric Spark notebook to ingest streaming data from an Azure Event Hubs instance into a Delta table in a Lakehouse. The stream must handle late-arriving data up to 15 minutes and ensure exactly-once processing. You also need to be able to restart the stream without reprocessing all data. What should you configure?
79You are building a Fabric Data Factory pipeline that ingests files from an Azure Blob Storage container into a Lakehouse. The source files are updated throughout the day, and you must process only files that have been added or modified since the last pipeline run. You also need to avoid reprocessing files that were already ingested. What should you configure in the pipeline?
80You are using a Dataflow Gen2 in Microsoft Fabric to transform data from an Azure SQL Database and load it into a Lakehouse. You need to apply a transformation that splits a full name column into first name and last name columns. Which Power Query transformation should you use?
81A data engineer is loading CSV files into a Fabric Lakehouse using a Data Factory Copy activity. The files contain dates formatted as DD/MM/YYYY and amounts using a comma as the decimal separator. When loaded with default settings, the dates and amounts are stored as strings and many values appear incorrect. The engineer needs the Lakehouse table to store these as proper date and decimal columns. What should the engineer configure in the Copy activity?
82You are using a Fabric Data Factory pipeline to copy semi-structured JSON files from an Azure Data Lake Storage Gen2 account into a Fabric Lakehouse. The JSON files contain nested arrays, and the business needs each element of those arrays flattened into its own row in the destination table. The pipeline must run unattended and produce a Delta table. Which approach should you use?
83You are designing a Fabric Data Pipeline to ingest data from an on-premises Oracle database into a Fabric Lakehouse. The pipeline must run daily and load only new and changed records since the last run. You have a self-hosted integration runtime installed and configured. Which two activities should you include in the pipeline to achieve incremental loading with minimal data movement? (Choose two.)
84You are designing a Fabric Data Factory pipeline that ingests data from an on-premises Oracle database into a Fabric Lakehouse. The pipeline must run on a schedule without manual intervention, and the data volume is large. You need to configure connectivity and performance. Which two actions should you perform? (Choose two.)
85You are ingesting streaming events into a Fabric Eventhouse using Eventstream. The events arrive with an event timestamp and an ingestion timestamp. Queries must return results based on when events actually occurred, and late-arriving events up to 30 minutes old must still be included. Which Eventhouse setting should you configure?
86You are using a Dataflow Gen2 to ingest and transform data from an Excel file stored in a SharePoint document library into a Fabric Lakehouse. The Excel file contains a column with mixed data types, and you need to ensure that the dataflow correctly interprets the column as Text. Which Power Query transformation should you apply?
87You are implementing a Fabric Data Factory pipeline that ingests JSON files from an Azure Data Lake Storage Gen2 account into a Lakehouse. The JSON files have a nested structure with an array of order items. You need to flatten the array so that each order item becomes a separate row in the Lakehouse table. Which transformation should you use in a data flow?
Be able to configure Dataflows Gen2, pipelines, and Copy activity end to end: pick the right gateway or integration runtime, choose Delta or Parquet for Lakehouse, and flatten nested JSON. The single most important thing is matching the source connector and destination to the required Fabric artifact and runtime.
The Courseiva DP-700 question bank contains 87 questions in the Ingest and Transform Data domain. Click any question to see the full explanation and answer breakdown.
Start with a 10-question focused session to identify your baseline accuracy in this domain. Read every explanation — even for questions you answer correctly — to understand the reasoning. Once you score consistently above 80%, move to a 20–30 question session to confirm depth before moving to the next domain.
Yes — the session launcher on this page draws questions exclusively from the Ingest and Transform Data domain. Choose 10, 20, 30, or 50 questions for a focused session, or click individual questions to review them one by one.
Save your results, see per-domain analytics, and get readiness scores — free, for every certification.
Sign Up FreeFree forever · Every certification included