Courseiva

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.

101 questions17 easy55 medium29 hard

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.

1

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)

Medium
2

You 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?

Medium
3

You 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)

Hard
4

You 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.

Hard
5

You 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?

Hard
6

You 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?

Medium
7

You 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?

Hard
8

When 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?

Easy
9

You 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?

Easy
10

You 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?

Medium
11

Refer 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?

Hard
12

Refer 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?

Hard
13

You 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.)

Hard
14

Refer 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?

Hard
15

You 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?

Medium
16

You 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?

Medium
17

You 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?

Medium
18

You 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?

Medium
19

You 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?

Easy
20

You 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?

Medium
21

You 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?

Medium
22

You 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?

Easy
23

You 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?

Hard
24

You 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?

Hard
25

You 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?

Easy
26

You 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?

Hard
27

You 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)

Hard
28

You 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?

Medium
29

You 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?

Medium
30

You 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?

Medium
31

Refer 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?

Hard
32

You 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?

Easy
33

You 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?

Medium
34

You 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?

Medium
35

You 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?

Medium
36

You 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?

Medium
37

You 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?

Medium
38

You 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?

Medium
39

Refer 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?

Medium
40

You 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?

Easy
41

Refer 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?

Medium
42

An 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?

Medium
43

You 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.)

Medium
44

You 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?

Medium
45

Which TWO factors are most important when choosing an partitioning strategy for a large Delta table in Microsoft Fabric?

Medium
46

You 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?

Hard
47

You 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?

Easy
48

You 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?

Medium
49

You 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?

Hard
50

You 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?

Medium
51

A 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?

Hard
52

You 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?

Medium
53

You 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?

Medium
54

You 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)

Hard
55

You need to automate the execution of a Notebook daily. Which Fabric tool should you use to orchestrate this workflow?

Medium
56

You 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?

Medium
57

A 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?

Easy
58

You 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?

Easy
59

You 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?

Hard
60

You 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?

Easy
61

You 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?

Hard
62

You 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?

Hard
63

You 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?

Hard
64

You 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.)

Hard
65

You 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?

Medium
66

You 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?

Medium
67

Refer 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?

Medium
68

You 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?

Medium
69

Which component in Fabric is responsible for orchestrating the overall data pipeline, including moving data and running transformations?

Easy
70

You 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?

Hard
71

Refer 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?

Hard
72

Your 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?

Medium
73

A 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?

Easy
74

Refer 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?

Medium
75

You 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?

Medium
76

You are designing a medallion architecture in Microsoft Fabric. Which THREE tasks are essential for the 'Silver' layer processing?

Medium
77

You 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?

Medium
78

You 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?

Hard
79

Refer 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?

Medium
80

Refer 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?

Hard
81

Refer 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?

Medium
82

You 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?

Medium
83

You 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?

Easy
84

Refer 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?

Medium
85

You 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?

Medium
86

You 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?

Hard
87

You 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?

Medium
88

You 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?

Medium
89

You 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?

Medium
90

You 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?

Medium
91

You 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)

Medium
92

You 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?

Hard
93

You 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?

Medium
94

You 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?

Medium
95

Your 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?

Medium
96

You 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?

Easy
97

You 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.)

Medium
98

You 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.

Hard
99

You 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?

Medium
100

You 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?

Easy
101

You 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?

Easy

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.
Microsoft Fabric Analytics Engineer Associate DP-600 Prepare Data Practice Questions