DP-600 · domain
Prepare Data
The Prepare Data domain of DP-600 covers ingesting and transforming data in Microsoft Fabric using pipelines, Dataflows Gen2, Spark notebooks, and T-SQL. Questions present realistic scenarios involving copy activities, self-hosted integration runtimes, Lakehouse and Warehouse destinations, schema handling, and transformation performance tuning, requiring you to choose the correct configuration or approach.
Focused practice
Practice Prepare Data questions
Scored sessions drawing only from this domain — pick a length below.
Start 20-question practice test →What this domain covers
What to know about Prepare Data
Be able to configure a Fabric pipeline copy activity with a self-hosted integration runtime and incremental filtering, optimize Dataflow Gen2 by preserving query folding, and handle schema drift in Spark notebooks. The most important thing is choosing the right tool and configuration so transformations stay performant and schema-safe.
Configuring Fabric pipeline copy activities, including incremental row filtering and self-hosted integration runtime setup
Building and optimizing Dataflow Gen2 transformations using Power Query and query folding against supported sources
Handling schema drift and missing columns in Spark notebooks with PySpark or Spark SQL
Choosing Lakehouse versus Warehouse destinations and applying T-SQL or Spark for data preparation
Watch out for
Common Prepare Data exam traps
- ▸Assuming copy activity incremental loads work without a watermark or change-tracking column; Fabric pipelines need explicit filtering logic, not automatic delta detection.
- ▸Ignoring query folding in Dataflow Gen2: transformations that break folding force local processing and severely degrade performance on large sources.
- ▸Using schema enforcement that fails on missing columns instead of handling drift; downstream code expecting absent columns must be addressed explicitly in the notebook.
Question index
All Prepare Data questions (101)
Click any question to see the full explanation, or start a practice session above.
You are developing a data pipeline in Microsoft Fabric. You need to choose between using a Shortcut and the 'Copy activity' to bring data from an existing Azure Data Lake Storage (ADLS) Gen2 account into your Fabric Lakehouse. What are THREE primary advantages of using Shortcuts over the Copy activity? (Select THREE)
Medium2You are using a Fabric Data Factory pipeline to copy data from an on-premises Oracle database to a Lakehouse. The pipeline must run every night and only copy rows that have changed since the last run. Which configuration should you use to achieve incremental data loading?
Medium3You are optimizing a Spark Notebook that processes large Parquet files in a Fabric Lakehouse. You want to ensure that the data is stored in a way that maximizes read performance for the SQL analytics endpoint. Which THREE features or techniques should you utilize? (Select THREE)
Hard4You are optimizing a large Delta table in a Microsoft Fabric Lakehouse. Users report slow query performance due to a high volume of small files and unsorted data across frequently filtered columns. Which TWO actions should you perform? Each correct answer presents part of the solution.
Hard5You are optimizing a Spark job in Fabric that processes large Parquet files. You notice high memory consumption and frequent spills to disk. Which TWO actions should you take to improve performance?
Hard6You are cleaning a dataset in a Fabric Notebook. You notice that your dataframe contains significant null values in the 'customer_id' column and you must remove these rows. Which PySpark command effectively achieves this filtering while maintaining dataframe immutability?
Medium7You are optimizing a Spark job in Fabric that processes large volumes of telemetry data. The job is failing due to memory overhead during a join operation on high-cardinality columns. Which TWO actions should you take to improve performance?
Hard8When preparing data in a Lakehouse, you need to enforce a schema on incoming JSON data before loading it into a Delta table. Which Fabric tool allows you to define and apply a structural schema programmatically?
Easy9You are creating a Fabric notebook to load data from a CSV file stored in the Lakehouse Files section into a Delta table. You want to use Spark to read the CSV and write it as a Delta table, ensuring that the schema is inferred correctly. Which code snippet should you use?
Easy10You are designing a data ingestion pipeline in Microsoft Fabric. You need to land raw CSV files from an external source into the Lakehouse. Which storage location should you use to ensure the data is optimized for delta table conversion and subsequent Lakehouse processing?
Medium11Refer to the exhibit. You are reviewing the M-code for a Dataflow Gen2. To ensure that the 'FilteredRows' step is executed on the source SQL Server rather than in the Fabric Mashup engine, what concept must be maintained?
Hard12Refer to the exhibit. You are reviewing a configuration for a maintenance task on a Delta table within a Microsoft Fabric Lakehouse. What is the primary benefit of ensuring the 'v_order' property is set to true during this operation?
Hard13You are using a Fabric Dataflow Gen2 to ingest data from a REST API that returns JSON. The JSON contains nested arrays and objects. You need to flatten the nested structures into a tabular format for loading into a Lakehouse. Which two actions should you perform in the Dataflow Gen2 query? (Choose two.)
Hard14Refer to the exhibit. You are implementing fine-grained access control in a Fabric Lakehouse using OneLake security roles. The exhibit shows a policy applied to a service account. What is the result when 'ServiceAccount_A' attempts to query the 'Sales' table?
Hard15You are using a Microsoft Fabric Notebook to process a large dataset stored in a Lakehouse. You need to ensure that the Spark job uses the most efficient method to handle many small files that have accumulated in the Delta table over time. Which operation should you perform?
Medium16You are building a medallion architecture in a Microsoft Fabric Lakehouse. Raw CSV files land daily in the Files section of the lakehouse. You need to ingest these files into a Delta table in the Bronze layer while ensuring schema evolution is automatically handled if new columns appear in the source files. Which command should you use in a PySpark notebook?
Medium17You are building a Fabric Dataflow Gen2 to ingest data from an on-premises SQL Server. The source table contains a column named 'OrderDate' stored as datetime2. In the Power Query editor, you need to convert this column to a date type and ensure that the resulting Delta table in the Lakehouse stores it as a date. Which transformation should you apply?
Medium18You have a Fabric Lakehouse with a Delta table named Sales. The table contains a column 'OrderDate' of type timestamp. You need to create a new table that contains only sales from the last 30 days, and you want to minimize storage and compute. What should you do?
Medium19You are creating a Dataflow Gen2 to ingest data from an Azure SQL Database into a Fabric Lakehouse. You need to ensure that only rows where the Status column equals 'Active' are loaded. Which transformation should you apply?
Easy20You are using a Fabric Dataflow Gen2 to transform data from an Azure SQL Database. The source table has a column 'OrderDate' of type datetime2. You need to extract the year and month from this column and create a new column 'YearMonth' in the format 'yyyy-MM'. Which transformation should you use?
Medium21You are using Fabric to ingest data. You notice that your data ingestion job is taking too long to complete. You want to parallelize the data load. Which strategy is most effective?
Medium22You are creating a Fabric pipeline that copies data from an on-premises Oracle database to a Lakehouse. The pipeline must run daily and only copy rows that have been modified since the last run. You need to configure the source to support incremental copying. What should you do?
Easy23You are loading a large CSV file from OneLake into a Delta table in a Fabric Lakehouse using a Spark notebook. The CSV contains a column 'TransactionDate' with values in the format 'MM/dd/yyyy'. After loading, you notice that the dates are stored as strings. You need to convert this column to a proper date type and then write the table. Which PySpark code snippet should you use?
Hard24You are creating a Dataflow Gen2 to ingest data from an on-premises Oracle database into a Fabric Lakehouse. The data volume is large, and you need to ensure that the dataflow uses the most efficient query folding. You notice that a custom column step is preventing folding. Which action should you take to restore query folding?
Hard25You are using a Fabric notebook to load a Parquet file from the Lakehouse Files section into a Spark DataFrame. You need to ensure that the schema is inferred correctly and that the data is read efficiently. Which PySpark code should you use?
Easy26You are monitoring a pipeline execution in Fabric. You notice that the 'Copy' activity is taking longer than expected. Which metric should you investigate to identify if the bottleneck is related to data movement throughput?
Hard27You are optimizing a Lakehouse for high-concurrency read operations from Power BI. You want to ensure that the Delta tables are in the best possible state for Direct Lake mode. Which THREE actions should you take during the 'Prepare Data' phase? (Select THREE)
Hard28You are creating a Fabric Dataflow Gen2 to ingest data from an on-premises Oracle database into a Lakehouse. The source table contains a column named 'LastModified' of data type TIMESTAMP WITH TIME ZONE. You need to ensure that the dataflow stores this column as a DateTime with time zone offset in the Lakehouse. What should you do?
Medium29You are preparing a large dataset in Fabric and need to remove duplicate rows based on multiple columns. Which approach is most efficient for a Delta table?
Medium30You are preparing a dataset in a Fabric Lakehouse. You want to ensure that users querying the data through the SQL analytics endpoint see the most up-to-date schema changes without manual refresh. How does Fabric handle this synchronization?
Medium31Refer to the exhibit. A data engineer runs this code in a Fabric Notebook to move data from the Bronze layer (Files) to the Silver layer (Tables). What is a potential performance risk of running this code repeatedly without modification?
Hard32You are creating a Dataflow Gen2 to ingest data from an OData source into a Lakehouse. The source contains a column 'OrderDate' stored as text in the format 'MM/dd/yyyy'. You need to convert this column to a Date type and load it into a Delta table. Which transformation should you use?
Easy33You are developing a data pipeline in Microsoft Fabric that ingests data from an on-premises SQL Server. You need to ensure that sensitive PII data is masked before it lands in the Lakehouse. Which transformation approach should you implement to maintain compliance while preserving data utility?
Medium34You are designing a data ingestion pipeline in Microsoft Fabric that loads millions of transactional rows daily from Azure Blob Storage into a Lakehouse table. The upstream data arrives as uncompressed CSV files containing frequently changing records. To ensure the downstream analytics queries maintain high performance and avoid performance degradation caused by small file proliferation, which configuration and format strategy should you implement?
Medium35You are designing a Fabric Lakehouse to store sales data. The data will be queried by a Power BI semantic model in Direct Lake mode. You need to ensure that the semantic model can efficiently handle queries that aggregate sales amounts by product category and time. Which Delta table optimization should you implement?
Medium36You are developing a Fabric Notebook to perform an ETL job. You need to ensure that the data processing remains atomic; if a failure occurs, the table should not contain partial data. What approach should you use?
Medium37You have a Fabric pipeline that ingests CSV files into a Lakehouse. The files sometimes contain rows with missing values in the 'OrderDate' column. You need to load only rows where 'OrderDate' is not null, and you want to minimize data movement. Which Dataflow Gen2 transformation should you use?
Medium38You are building a data transformation pipeline using Dataflow Gen2 in Microsoft Fabric. You need to combine two queries containing customer information and sales transactions based on a shared customer ID column, ensuring that all records from the customer table are retained even if they have no matching sales. Which join kind should you select?
Medium39Refer to the exhibit. You are writing PySpark code in a Fabric notebook to combine sales and product information. Given the configuration, what is the primary behavior of this merge operation?
Medium40You are creating a Fabric Dataflow Gen2 to transform data from a CSV file. Which feature should you use if you want to preview the impact of your transformations on a sample set of data before applying them to the entire dataset?
Easy41Refer to the exhibit. This SQL code is executed in a Microsoft Fabric Notebook. What is the primary purpose of this operation in the context of data preparation?
Medium42An organization is migrating a 2 TB dataset from an on-premises SQL Server to a Microsoft Fabric Lakehouse. The data contains complex transformations that require high performance and the ability to handle data skewed across multiple partitions. Which tool should you use to ensure the most scalable and performant ingestion and transformation process?
Medium43You need to optimize the storage of a large dataset in a Fabric Lakehouse using Delta Lake format. Which TWO actions should you perform to improve query performance? (Choose two.)
Medium44You are building a Fabric Dataflow Gen2 to ingest data from a REST API that returns JSON. The API response includes a nested array of order line items under an 'orders' property, and each line item contains a 'productId' and 'quantity'. You want to flatten this structure into a single table with one row per line item, preserving the parent order ID. Which Dataflow Gen2 transformation should you use?
Medium45Which TWO factors are most important when choosing an partitioning strategy for a large Delta table in Microsoft Fabric?
Medium46You are using Fabric Dataflows Gen2 to ingest data from an API. You need to ensure the process is resilient. Which THREE features should you implement?
Hard47You are using Fabric Dataflow Gen2 and need to merge data from two different sources. Which transformation would you use to combine the datasets based on a common key, similar to a SQL JOIN operation?
Easy48You are migrating data from an on-premises data warehouse to Fabric. You need to ensure the schema of the migrated data remains intact. What should you use to define the schema?
Medium49You are preparing data in a Fabric Lakehouse using a Spark notebook. You need to merge a DataFrame containing updates into an existing Delta table to perform an upsert. The Delta table is named 'silver.customers' and the merge condition is on 'CustomerID'. Which PySpark code should you use?
Hard50You are using a Fabric Data Pipeline to copy data from a REST API endpoint that returns JSON. The API requires an OAuth2 token for authentication. You need to configure the pipeline to securely authenticate and retrieve the data. What should you do?
Medium51A Fabric Lakehouse table named Sales is stored in Delta format and contains a column OrderDate of type string holding values such as '2024-03-15'. Analysts complain that range filters on this column are slow and that date functions fail. You must convert the column to a proper date type in place while preserving the existing table and its history. You are using a Fabric notebook with Spark. Which approach should you use?
Hard52You are building a Fabric data pipeline that ingests CSV files from an Azure Data Lake Storage Gen2 account into a Lakehouse. The files arrive daily and contain a header row, but some rows have missing values in the 'TransactionAmount' column. You need to load only rows where 'TransactionAmount' is not null into a Delta table, while preserving all other columns. Which Dataflow Gen2 transformation should you use?
Medium53You are using a Fabric pipeline to copy data from an on-premises Oracle database to a Lakehouse. The pipeline must run incrementally, loading only new or changed records since the last run. Which configuration should you use in the Copy activity?
Medium54You are managing a Lakehouse in Microsoft Fabric and need to maintain the health and performance of your Delta tables. Which TWO maintenance tasks should you perform regularly? (Select TWO)
Hard55You need to automate the execution of a Notebook daily. Which Fabric tool should you use to orchestrate this workflow?
Medium56You are preparing a dataset in a Microsoft Fabric Notebook using PySpark. You have a DataFrame 'df' with a column 'Price' that contains some null values. You need to replace these null values with the average price of the entire dataset. Which approach is most appropriate?
Medium57A data engineer is preparing a Fabric Lakehouse table that will be queried by a Direct Lake semantic model. The table is created by a notebook that writes Parquet files into a folder in the Lakehouse, and the engineer notices the table does not appear in the SQL analytics endpoint. The engineer wants the folder to be recognized as a managed Delta table. What should the engineer do?
Easy58You have a Lakehouse in Microsoft Fabric that contains several Delta tables. You need to provide a SQL-based analyst with the ability to query these tables using their preferred desktop tool, such as SQL Server Management Studio (SSMS). What should you provide to the analyst?
Easy59You are processing streaming data in Fabric. You need to ensure that duplicate events are handled correctly before writing to the Lakehouse. What should you use?
Hard60You are creating a Fabric Lakehouse and need to store raw CSV files that will be processed later by notebooks. You want to organize these files in a folder structure that separates data by year and month. Where should you store these files in the Lakehouse?
Easy61You are using a Fabric notebook to read a Delta table from a Lakehouse. You need to optimize read performance for a query that filters on a high-cardinality column 'CustomerID' and also on a low-cardinality column 'Region'. The table is large and partitioned by 'Region'. Which optimization technique should you implement?
Hard62You have a dataset with a highly skewed distribution in a join key. When performing a join in a Spark notebook, you observe performance degradation. Which technique should you use to handle this skew?
Hard63You are designing a Medallion architecture in Microsoft Fabric. You have a Silver layer table that is frequently updated with new records and changes to existing records. You need to ensure that the process maintains historical versions of the data for auditing while optimizing query performance for the latest state. Which implementation strategy is best?
Hard64You are using a Fabric notebook to ingest data from multiple CSV files in a Lakehouse Files area into a Delta table. The files are updated daily, and you need to perform an incremental load that only processes new or changed files. You also need to ensure that the load is idempotent to avoid duplicates if the notebook is rerun. Which two actions should you perform? (Choose two.)
Hard65You are using a Fabric notebook to read a large Parquet file from the Lakehouse Files section and write it to a Delta table. You need to optimize the write operation to handle the large file efficiently. Which Spark setting should you configure?
Medium66You have a large Delta table in a Fabric Lakehouse that is experiencing performance degradation. You observe that the table contains thousands of small files. What command should you use to optimize the table?
Medium67Refer to the exhibit. You are configuring a pipeline to load data from RawStorage to a Bronze Lakehouse. The current configuration results in slow query performance when reading from the Lakehouse. What change should you make to the configuration?
Medium68You are building a Fabric data pipeline that reads JSON files from OneLake. The files contain nested arrays and you need to flatten them into a tabular structure before loading into a Lakehouse table. You want to minimize custom code and use built-in capabilities. What should you use?
Medium69Which component in Fabric is responsible for orchestrating the overall data pipeline, including moving data and running transformations?
Easy70You are implementing a Medallion architecture in Microsoft Fabric. You have a requirement to ensure that only cleaned, validated data reaches the Silver layer. Which tool is best suited for this gatekeeping process?
Hard71Refer to the exhibit. You are implementing a partitioning strategy for a table with 5 years of daily transaction data. The 'TransactionDate' column is a timestamp. What is the most likely performance issue with this code as written?
Hard72Your organization is implementing a medallion architecture in Microsoft Fabric. You need to ingest raw CSV data from an Azure Data Lake Storage (ADLS) Gen2 account into a Lakehouse. The data requires complex transformations, including pivoting and multi-level joins, before it is ready for the Silver layer. Which tool should you use to provide a low-code environment for these transformations?
Medium73A data engineer needs to quickly transform a small Excel file stored in OneLake and load it into a Lakehouse table. The engineer prefers a visual, no-code interface. Which Fabric component is most appropriate?
Easy74Refer to the exhibit. You are configuring a copy activity to ingest JSON data into a Delta table. You notice that the target table schema is not reflecting the nested structure of the JSON correctly. What should you do to fix this?
Medium75You are designing a data ingestion pipeline in Microsoft Fabric. You need to ingest data from an on-premises SQL Server database into a Lakehouse. Which integration tool should you use to ensure secure, scalable connectivity while minimizing administrative overhead?
Medium76You are designing a medallion architecture in Microsoft Fabric. Which THREE tasks are essential for the 'Silver' layer processing?
Medium77You are using a Fabric pipeline to copy data from an on-premises Oracle database to a Lakehouse. The pipeline uses a self-hosted integration runtime. You need to ensure that the copy activity only transfers rows modified in the last 24 hours to reduce load. Which pipeline component should you configure?
Medium78You are creating a Fabric pipeline that uses a Copy activity to load data from an on-premises Oracle database into a Lakehouse. The Oracle source has a column of type TIMESTAMP WITH TIME ZONE. You need to preserve the time zone information in the Lakehouse. Which data type should you map the source column to in the Lakehouse table?
Hard79Refer to the exhibit. You are reviewing a JSON configuration for a Fabric item. What is the primary outcome of deploying this configuration in a Microsoft Fabric workspace?
Medium80Refer to the exhibit. You are processing data in a Spark Notebook. The schema of the incoming data does not contain the 'date_col' column, but your downstream code expects it. What is the most efficient way to handle this?
Hard81Refer to the exhibit. You are using a notebook to read data from a source SQL database. To ensure the read operation is parallelized, what technique should you apply?
Medium82You are building a Fabric Dataflow Gen2 to ingest a large CSV file from Azure Blob Storage into a Lakehouse. The source file contains customer records, and you must ensure that the Email column is populated and follows a valid format before loading. You need to implement a data quality check that prevents invalid rows from reaching the destination. What should you configure in the Dataflow Gen2?
Medium83You have a CSV file with headers in the first row. Using a Spark notebook in Fabric, which code snippet correctly reads this file into a DataFrame?
Easy84Refer to the exhibit. You are running a Spark job to load sales data. The 'overwrite' mode is set. What is the impact of this operation on the target table?
Medium85You are using Fabric Dataflows Gen2 to ingest data. You notice that your Dataflow is slow. You want to see if the Dataflow is executing 'Mashup' queries on the source or the Fabric engine. Which tool should you use?
Medium86You are using a Fabric notebook to read a large Delta table from a Lakehouse. You need to minimize the amount of data scanned and improve query performance when filtering on a high-cardinality column named TransactionID. Which technique should you use?
Hard87You have a Fabric Lakehouse with a Delta table named Sales. The table receives frequent updates, and you notice that query performance has degraded over time. You need to improve read performance by optimizing the physical layout of the data files without changing the table schema. Which action should you perform?
Medium88You are creating a shortcut in a Microsoft Fabric Lakehouse to access data stored in an Azure Data Lake Storage (ADLS) Gen2 account. What is the primary benefit of using a shortcut instead of copying the data?
Medium89You are designing a data ingestion pipeline in Microsoft Fabric. You need to ingest data from an on-premises SQL Server database into a Lakehouse. Which integration runtime component should you configure to ensure secure connectivity?
Medium90You are troubleshooting a slow-running Spark job in a Fabric notebook. Which TWO metrics should you analyze to identify potential bottlenecks in your data processing job?
Medium91You are designing a data ingestion strategy from an on-premises SQL Server to a Microsoft Fabric Lakehouse. You want to utilize the 'Fast Copy' feature in Dataflows Gen2 to maximize throughput. Which TWO conditions must be met to enable this capability? (Select TWO)
Medium92You are preparing data in a Microsoft Fabric Lakehouse. A Delta table named CustomerTransactions contains millions of rows and is frequently updated with new transactions and corrections to existing ones. You need to apply incremental updates from a staging table StagingTransactions that includes both new records and updates to existing records based on a TransactionID. You must ensure that the final table reflects the latest data without duplicates. Which approach should you use?
Hard93You are designing a data pipeline that must handle late-arriving data. Which strategy ensures that your reports are consistent even when data arrives after the scheduled batch window?
Medium94You are loading a large CSV file into a Fabric Lakehouse using a Dataflow Gen2. The CSV contains date columns stored as text in MM/dd/yyyy format. You need to ensure these columns are loaded into a Delta table as proper date types. Which transformation should you apply in the Dataflow Gen2 Power Query editor?
Medium95Your team is using Microsoft Fabric to build a data platform. You need to provide a way for data scientists to explore raw data files in a Lakehouse using Python, while also allowing SQL developers to query the same data as tables. What is the most efficient way to achieve this?
Medium96You are using a Fabric Notebook to explore data. You want to view the distribution of a numeric column in your dataframe. Which tool provides the fastest way to visualize this without writing additional code?
Easy97You are preparing data in a Fabric Lakehouse using Spark. You have a Delta table 'Sales' with columns 'ProductID', 'SaleDate', and 'Amount'. You need to optimize the table for queries that filter on 'SaleDate' and 'ProductID'. Which two actions should you perform? (Choose two.)
Medium98You are cleaning data using a Dataflow Gen2 in Microsoft Fabric. You need to optimize the performance of the transformation process. Which TWO actions should you perform? Each correct answer represents a complete solution.
Hard99You are building a Fabric Dataflow Gen2 that ingests a CSV file from a Lakehouse Files area. The file contains a column named 'TransactionDate' stored as text in the format 'MM/dd/yyyy'. You need to convert this column to a proper Date type to enable time intelligence in a downstream semantic model. Which Power Query M transformation should you apply?
Medium100You are building a Dataflow Gen2 that combines data from two Lakehouse tables: 'Sales' and 'Products'. You need to join them on 'ProductID' and keep all rows from 'Sales' even if there is no matching product. Which join kind should you select?
Easy101You need to access data stored in an Azure Data Lake Storage (ADLS) Gen2 account from a Microsoft Fabric Lakehouse without physically moving or copying the data. The goal is to minimize storage costs and maintain a single source of truth. Which feature should you implement?
EasyOther domains
All DP-600 exam domains
Frequently asked questions
- What does the Prepare Data domain cover on the DP-600 exam?
- Be able to configure a Fabric pipeline copy activity with a self-hosted integration runtime and incremental filtering, optimize Dataflow Gen2 by preserving query folding, and handle schema drift in Spark notebooks. The most important thing is choosing the right tool and configuration so transformations stay performant and schema-safe.
- How many questions are in this domain?
- This page lists all 101 Prepare Data questions in the DP-600 question bank. The actual exam draws from this domain proportionally to its weighting in the official exam blueprint.
- What is the best way to practise this domain?
- Start with a short focused session (10 questions) to identify gaps, then work through explanations. Repeat with a longer session once the weak areas feel solid.
- Can I practise only Prepare Data questions?
- Yes — the session launcher on this page filters questions to this domain only. Choose any session length for inline explanations and scoring.