Practice exam only
€18.99
30 days · Labs not included.
View exam access →DP-900 · Hands-on practice
DP-900 Hands-on Labs — practise in a simulated Azure portal and Microsoft Fabric
Learn it. Practise it. Make it stick.
36 practical tasks + 3 troubleshooting challenges. Familiar administration workflows, gradual hints and explanations. 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-900 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.
DP-900 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.
Certificate of Completion
Finish the course. Prove it.
Complete all 36 labs and you can download a certificate of completion with your name, the skills you practised and a unique ID. Challenges are optional. Anyone can check it on a public verification page — and add it to LinkedIn in one click.
- Not self-declared. Before issuing, our server re-runs the grader on every lab you saved, so a checkbox in your browser is not enough.
- Verifiable. Every certificate has its own page at examitlab.com/verify/<ID>.
- Honest. It certifies that you completed this course. It is independent training, not an official certification.
ExamIT Lab
Certificate of Completion
Data Fundamentals
Hands-on skills course · DP-900 track · 36 graded labs
Alex Morgan
has completed every hands-on lab of the course. Each task was graded on the configuration and the data decisions left in simulated cloud data workspaces — not on the clicks made.
Data formats & storesTransactional & analytical workloadsData rolesRelational design & SQLDatabase servicesNon-relational dataAnalytics pipelinesReporting & visualization
Completed
4 October 2026
4 October 2026
36/36labs
Certificate ID
DTF-7K4Q-2M9D-X8
DTF-7K4Q-2M9D-X8
Verify at examitlab.com/verify/DTF-7K4Q-2M9D-X8. This is a certificate of course completion issued by ExamIT Lab. It is independent training and not an official certification of any vendor.
Sample certificate — name and ID are fictional.
Your learning path
Work through the tasks in order — each one builds on the last.
LAB 01 · FREE
Classify six datasets: structured, semi-structured, unstructured
Data classification · 6–8 min
Open lab →LAB 02 · FREE
Create an Azure SQL Database
SQL databases · 10–12 min
Open lab →LAB 03 · FREE
Cosmos DB: consistency level and partition key
Azure Cosmos DB · 10–12 min
Open lab →LAB 04 · FREE
Batch or streaming?
Data processing · 6–8 min
Open lab →LAB 05 · FREE
Build a report page: pick the right visuals
Power BI report · 10 min
Open lab →LAB 06 · LOCKED
Pick the file format for each export
File formats · 8–10 min
Included with full DP-900 lab access
LAB 07 · LOCKED
Read three files and decide: schema-on-write or schema-on-read
Data files · 8–10 min
Included with full DP-900 lab access
LAB 08 · LOCKED
Match workloads to data store models
Data stores · 8–10 min
Included with full DP-900 lab access
LAB 09 · LOCKED
Choose the Azure data store for eight use cases
Azure data stores · 10 min
Included with full DP-900 lab access
LAB 10 · LOCKED
Read a bank transfer: is it a transactional workload? (ACID)
Transactions · 8–10 min
Included with full DP-900 lab access
LAB 11 · LOCKED
Transactional or analytical? Classify ten workloads
Workload types · 10 min
Included with full DP-900 lab access
LAB 12 · LOCKED
Route ten data tasks to the right data role
Data roles · 8 min
Included with full DP-900 lab access
LAB 13 · LOCKED
Staff the Fabrikam data project: roles, workload, store
Data project · 10–12 min
Included with full DP-900 lab access
LAB 14 · LOCKED
Fix three broken records: CSV, JSON, XML
Data file formats · 8–10 min
Included with full DP-900 lab access
LAB 15 · LOCKED
Design tables: keys and relationships
Table keys · 8–10 min
Included with full DP-900 lab access
LAB 16 · LOCKED
Normalize a flat orders table
Normalization · 10–12 min
Included with full DP-900 lab access
LAB 17 · LOCKED
Pick the SQL statement or category
SQL statements · 8–10 min
Included with full DP-900 lab access
LAB 18 · LOCKED
Assemble a SELECT: JOIN, WHERE, GROUP BY
Query builder · 10 min
Included with full DP-900 lab access
LAB 19 · LOCKED
View, index, stored procedure or something else?
Database objects · 8–10 min
Included with full DP-900 lab access
LAB 20 · LOCKED
Create a view and an index in the Azure SQL query editor
SQL databases · 10–12 min
Included with full DP-900 lab access
LAB 21 · LOCKED
Azure SQL family: Database, Managed Instance or SQL Server on a VM?
Azure SQL family · 8–10 min
Included with full DP-900 lab access
LAB 22 · LOCKED
Open-source databases on Azure: PostgreSQL, MySQL, MariaDB
Azure Database for PostgreSQL / MySQL · 8–10 min
Included with full DP-900 lab access
LAB 23 · LOCKED
Create a storage account and a blob container
Storage accounts · 10–12 min
Included with full DP-900 lab access
LAB 24 · LOCKED
Blob access tiers and redundancy for six datasets
Blob access tiers · 10 min
Included with full DP-900 lab access
LAB 25 · LOCKED
Azure Files or Blob? Create a file share
File shares · 8–10 min
Included with full DP-900 lab access
LAB 26 · LOCKED
Design a Table storage entity: PartitionKey and RowKey
Table storage · 8–10 min
Included with full DP-900 lab access
LAB 27 · LOCKED
When is Azure Cosmos DB the right choice?
Azure Cosmos DB · 8–10 min
Included with full DP-900 lab access
LAB 28 · LOCKED
Pick the Cosmos DB API
Cosmos DB APIs · 8–10 min
Included with full DP-900 lab access
LAB 29 · LOCKED
ETL or ELT? Order the pipeline
Data Factory ETL and ELT · 8–10 min
Included with full DP-900 lab access
LAB 30 · LOCKED
Build a copy pipeline
Data Factory pipeline · 10–12 min
Included with full DP-900 lab access
LAB 31 · LOCKED
Data warehouse, data lake or lakehouse?
Fabric data stores · 8–10 min
Included with full DP-900 lab access
LAB 32 · LOCKED
Pick the Microsoft analytics service
Fabric and Databricks services · 10 min
Included with full DP-900 lab access
LAB 33 · LOCKED
Microsoft Fabric: workspace, lakehouse, warehouse
Microsoft Fabric · 10–12 min
Included with full DP-900 lab access
LAB 34 · LOCKED
Read an analytics architecture: ingest, store, process, serve
Analytics architecture · 10–12 min
Included with full DP-900 lab access
LAB 35 · LOCKED
Stream telemetry: Event Hubs and Stream Analytics
Stream Analytics jobs · 10–12 min
Included with full DP-900 lab access
LAB 36 · LOCKED
Shape a Power BI data model
Power BI semantic model · 10–12 min
Included with full DP-900 lab access
Troubleshooting challenges
Inspect evidence, identify the cause, make a safe fix and verify it. 3 separate exercises, included with full DP-900 lab access.
Orders are being throttled (429)
8–10 min
Locked · Full lab access required
The storage bill doubled
8–10 min
Locked · Full lab access required
Revenue is double-counted in the Power BI report
10–12 min
Locked · Full lab access required
DP-900 hands-on labs — questions
- Does DP-900 have labs, and can I practise them without a tenant?
- Yes. ExamIT Lab gives you 36 guided DP-900 labs in a simulated Azure portal and Microsoft Fabric. 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-900 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 36 labs plus 3 troubleshooting challenges is a one-time purchase with no subscription.
- What does a DP-900 lab look like?
- Each lab opens a realistic simulation of Azure and Microsoft Fabric data workspaces — classifying data and file formats, transactional and analytical workloads, data roles, relational keys, normalization and SQL statements, Azure SQL Database, PostgreSQL and MySQL services, Blob, Files and Table storage, Azure Cosmos DB consistency, partition keys and APIs, ETL and ELT pipelines, Fabric, Databricks and Stream Analytics, Power BI data models and report visuals. You get a task brief, a guided or independent mode, progressive hints and a "Check configuration" button that grades the actual end state you left behind — not just the buttons you clicked.
- Do the labs cover the current DP-900 exam outline?
- The labs are mapped to the objectives in Microsoft's current DP-900 study guide, and we re-audit the mapping when Microsoft updates the skills measured. Combine them with the DP-900 practice test on ExamIT Lab for full coverage.
- Is there a certificate at the end?
- Yes. When all 36 labs are complete you can issue a certificate of completion in your account: a PDF with your name and a unique ID, an Add to LinkedIn link and a public verification page. Before issuing, the server re-runs the course grader on every lab you saved, so it reflects work you really did. It certifies completion of this course; it is independent training, not an official certification.
- How is this different from a Microsoft Learn sandbox or a trial tenant?
- A trial tenant gives you a blank environment and no feedback. These labs give you a pre-built scenario with fictional users, devices and policies, a clear goal, and automatic checking of your result — so you practise the exact administration workflows the DP-900 exam expects, in minutes, not hours of setup.
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.