DP-700 · Hands-on practice

DP-700 Hands-on Labs — practise in a simulated Microsoft Fabric workspace

Learn it. Practise it. Make it stick.

30 practical tasks. From raw retail data to a trusted analytics result: access, ingestion, supported SQL, PySpark and KQL, and failure diagnosis. Independent simulation — no real tenant, device or cloud resources.

First five tasks are free, repeatable and have no expiry · No credit card required.

Access options

One-time payments, no automatic renewal. The first five tasks stay free either way.

DP-700 Hands-on Labs

€14.99

All labs for this course. 30 days from payment confirmation.

One-time payment · No automatic renewal.

Purchases are temporarily unavailable. Enjoy your 5 open tasks.

Best value

DP-700 Practice Exam + Hands-on Labs

€29.99

Save €3.99. Exam and all labs each get 60 days.

One-time payment · No automatic renewal.

Purchases are temporarily unavailable. Enjoy your 5 open tasks.

Your learning path

Follow the retail data scenario or repeat any task independently. Each lab supplies its own prepared data and workspace state.

LAB 01 · FREE

Give an engineer the right workspace role

Workspace access · 8–12 min

Open lab →

LAB 02 · FREE

Land the raw sales file

Copy activity · 8–12 min

Open lab →

LAB 03 · FREE

Remove exact duplicate order rows

Notebook · 12–18 min

Open lab →

LAB 04 · FREE

Aggregate the curated sales by region

SQL analytics endpoint · 12–18 min

Open lab →

LAB 05 · FREE

Repair a failed copy mapping

Copy activity · 8–12 min

Open lab →

LAB 06 · LOCKED

Protect the curated customer item

Sensitivity label · 8–12 min

Included with full DP-700 lab access

LAB 07 · LOCKED

Use the approved Spark environment

Spark settings · 8–12 min

Included with full DP-700 lab access

LAB 08 · LOCKED

Connect a feature branch to source control

Git integration · 8–12 min

Included with full DP-700 lab access

LAB 09 · LOCKED

Prepare the test deployment stage

Deployment pipeline · 8–12 min

Included with full DP-700 lab access

LAB 10 · LOCKED

Restrict a reader to the curated table

OneLake security · 8–12 min

Included with full DP-700 lab access

LAB 11 · LOCKED

Schedule ingestion after the source closes

Pipeline schedule · 8–12 min

Included with full DP-700 lab access

LAB 12 · LOCKED

Pass the batch date to the notebook

Notebook activity · 8–12 min

Included with full DP-700 lab access

LAB 13 · LOCKED

Share a Spark session safely

Spark high concurrency · 8–12 min

Included with full DP-700 lab access

LAB 14 · LOCKED

Share an item without sharing administration

Item permissions · 8–12 min

Included with full DP-700 lab access

LAB 15 · LOCKED

Load only the new watermark interval

Incremental copy · 8–12 min

Included with full DP-700 lab access

LAB 16 · LOCKED

Reference products without copying them

OneLake shortcut · 8–12 min

Included with full DP-700 lab access

LAB 17 · LOCKED

Keep valid, positive retail sales

Notebook · 12–18 min

Included with full DP-700 lab access

LAB 18 · LOCKED

Enrich sales with the product category

Warehouse · 12–18 min

Included with full DP-700 lab access

LAB 19 · LOCKED

Route only completed checkout events

Eventstream · 8–12 min

Included with full DP-700 lab access

LAB 20 · LOCKED

Summarize revenue in five-minute windows

KQL queryset · 12–18 min

Included with full DP-700 lab access

LAB 21 · LOCKED

Prepare the region dimension

SQL analytics endpoint · 12–18 min

Included with full DP-700 lab access

LAB 22 · LOCKED

Handle a conversion error explicitly

Dataflow Gen2 · 8–12 min

Included with full DP-700 lab access

LAB 23 · LOCKED

Fix the notebook table reference

Notebook · 12–18 min

Included with full DP-700 lab access

LAB 24 · LOCKED

Restore access to a shortcut target

Shortcut connections · 8–12 min

Included with full DP-700 lab access

LAB 25 · LOCKED

Repair an Eventhouse destination

Eventstream · 8–12 min

Included with full DP-700 lab access

LAB 26 · LOCKED

Compact small files without losing retention

Lakehouse maintenance · 8–12 min

Included with full DP-700 lab access

LAB 27 · LOCKED

Tune copy parallelism from measured evidence

Copy activity · 8–12 min

Included with full DP-700 lab access

LAB 28 · LOCKED

Project and filter a warehouse query

Warehouse · 12–18 min

Included with full DP-700 lab access

LAB 29 · LOCKED

Alert on a sustained ingestion failure

Activator · 8–12 min

Included with full DP-700 lab access

LAB 30 · LOCKED

Find the failed ingestion runs

KQL queryset · 12–18 min

Included with full DP-700 lab access

DP-700 hands-on labs — questions

Does DP-700 have labs, and can I practise them without a tenant?
Yes. ExamIT Lab gives you 30 guided DP-700 labs in a simulated Microsoft Fabric workspace. Nothing is deployed to a real Microsoft tenant, subscription or device, so there is nothing to set up, nothing to pay Microsoft for, and nothing you can break.
Are the DP-700 labs free?
The first 5 labs in the learning order are free, repeatable and never expire — no credit card and no sign-up required to start. The full course of 30 labs is a one-time purchase with no subscription.
What does a DP-700 lab look like?
Each task opens a prepared retail data scenario in a focused Microsoft Fabric teaching workspace. Change saved settings, run supported transformations and inspect output rows and diagnostics. Check my work assesses the saved state and current run results. Every task starts independently.
Do the labs cover the current DP-700 exam outline?
These 30 tasks practise selected objectives in the three DP-700 domains, with ten tasks each for managing an analytics solution, ingesting and transforming data, and monitoring and optimization. The mapping follows skills measured as of October 19, 2026. This is not complete coverage of every exam objective; combine the labs with official Microsoft training.
How is this different from a Microsoft Learn sandbox or a trial tenant?
The browser engine processes supplied fictional rows with a bounded set of SQL, PySpark and KQL operations and configuration workflows. It provides repeatable starting data and result checks without Fabric capacity. It cannot run arbitrary code, connect to data sources, grant real permissions or deploy Fabric items.

Access is per course. Sign in for account progress. After paid access expires, your saved progress is retained and the first five tasks remain free.