Black Friday50% off your first month on any monthly plan with EARLY50 See plans
Three learners at laptops cheering as data flows from the cloud through a pipeline into a lakehouse, with a trophy, flashcards and a stopwatch nearby.

Free courses · Venky

DP-700 exam prep: Microsoft Fabric Data Engineer, from zero to pass

A free, complete prep course for exam DP-700: cloud basics to two timed mock exams, every lesson mapped to Microsoft's skills outline.

33 lessons · about 13 hours · Free

Leaderboard

Loading…

50 XP for each lesson you finish, 10 for each right answer. Names show only for learners who turn on Show me on leaderboards.

About the instructor

Venky

Free, complete courses for people learning on their own time. Every lesson is checked against the official documentation and cites the page each fact comes from.

3 courses · 97 lessons

What it is

DP-700 is Microsoft's exam for the Fabric Data Engineer Associate certification: ingest, transform, secure, monitor and optimize data in Microsoft Fabric.

DP-700 covers a lot of Microsoft Fabric, and the official docs link deeper at every step, so it's easy to study the wrong things for weeks. This course teaches exactly what the exam measures, at the depth it measures it, with real workplace scenarios, daily review and two timed mock exams.

What you'll be able to do

  • Pass DP-700 by studying the exact skills Microsoft measures, at the depth the exam needs
  • Choose the right Fabric store, tool and loading pattern for a workplace scenario
  • Secure, deploy and orchestrate a Fabric data solution from development to production
  • Ingest and transform batch and streaming data with pipelines, notebooks, SQL and KQL
  • Monitor, troubleshoot and optimize Fabric items when something is slow or broken

Who it's for

Anyone taking DP-700, including people with no cloud background; module 1 covers the basics and a quick check tells you what to skip.

Not for Power BI report design (that's PL-300) or for Azure administration.

How it starts

It's Monday at Northwind Rides, a city bike-and-scooter rental company. You've just joined as its data engineer. By Friday the ops manager wants a report of scooter trips by station, and finance wants payment data it can trust. The data sits in four different places, and none of them talk to each other.

DP-700 is Microsoft's exam for the Microsoft Certified: Fabric Data Engineer Associate certification. Its full title is Implementing Data Engineering Solutions Using Microsoft Fabric.

Microsoft Fabric is Microsoft's analytics platform. It brings data storage, data movement,…

What you'll learn

  1. Start here: cloud and data basics

    1. Start here: the exam, the plan and what you already know

      See what DP-700 tests, how this course gets you to a pass on your schedule, and where you should start.

    2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits

      Explain what the cloud is and why Fabric is a SaaS product, so later lessons make sense.

    3. Data basics: files, tables, formats and the lakehouse idea

      Tell files from tables, pick the right format, and see why Fabric stores tables as Delta.

    4. A tour of Microsoft Fabric: OneLake, workspaces and items

      Name every Fabric experience and item a data engineer uses and how they share one copy of data.

    5. The three languages: SQL, PySpark and KQL side by side

      Read and write the basic queries the exam shows in SQL, PySpark and KQL.

    6. Getting data in: the map of Fabric tools

      Know every way data gets into Fabric and the one question that picks each tool.

  2. Store, ingest and transform batch data (exam area 2, 30-35%)

    1. Choosing a data store and a transformation tool

      Pick Lakehouse, Warehouse or Eventhouse, and Dataflow Gen2, notebook or T-SQL, from a scenario.

    2. Shortcuts and mirroring: use data without copying it

      Reach data in other places with shortcuts and keep a live copy of a database with mirroring.

    3. Ingest data with pipelines and Copy job

      Copy data from a source into a lakehouse or warehouse with the Copy activity or a Copy job.

    4. Transform with PySpark and SQL: join, denormalize, aggregate

      Shape raw tables into analytics tables with joins, grouping and aggregations.

    5. Messy data: duplicates, missing values and late arrivals

      Find and fix duplicate, missing and late-arriving data before it reaches reports.

    6. Full and incremental loads, and loading a star schema

      Design full and incremental loads and prepare data for fact and dimension tables.

  3. Orchestrate and stream (exam areas 1 and 2)

    1. Pipeline or notebook? Choosing how to orchestrate

      Pick between a pipeline and a notebook for a job and combine them when needed.

    2. Schedules and event-based triggers

      Run pipelines and notebooks on a schedule or when something happens.

    3. Parameters and dynamic expressions

      Make one pipeline or notebook handle many tables with parameters and expressions.

    4. Streaming in Fabric: Eventstreams, Spark streaming and KQL

      Pick the right streaming engine and load streaming data into Fabric.

    5. KQL and windowing functions for real-time data

      Query streaming data with KQL and group events into time windows.

  4. Set up and secure a Fabric solution (exam area 1, 30-35%)

    1. Workspace settings: Spark, domains, OneLake and data workflows

      Configure the workspace settings the exam asks about and know what each one changes.

    2. Version control with Git and database projects

      Connect a workspace to Git, commit and update items, and use database projects for warehouses.

    3. Deployment pipelines: development, test and production

      Move content between stages with deployment pipelines and change settings per stage.

    4. Who can see what: workspace roles and item permissions

      Grant the least access a person needs with workspace roles and item-level sharing.

    5. Fine-grained security: rows, columns, objects, files and masking

      Restrict which rows and columns people see and mask sensitive values in Fabric.

    6. Governance: sensitivity labels and endorsement

      Label sensitive items and mark trusted ones so people find the right data.

  5. Monitor, fix and optimize (exam area 3, 30-35%)

    1. Monitoring hub, alerts and Activator

      Watch ingestion, transformations and refreshes and get alerted when something breaks.

    2. Fixing errors in pipelines, dataflows and notebooks

      Read the error, find the cause and fix failing pipelines, dataflows and notebooks.

    3. Fixing errors in Eventhouse, Eventstream and T-SQL

      Diagnose real-time and SQL errors and know where each one is reported.

    4. Optimize lakehouse tables: V-Order, OPTIMIZE, VACUUM and partitions

      Keep Delta tables fast and small with V-Order, compaction, vacuum and sensible partitions.

    5. Optimize Spark, pipelines and warehouses

      Speed up Spark jobs, pipelines and warehouse queries with the settings the exam names.

    6. Optimize eventstreams, eventhouses and queries

      Keep real-time pipelines and queries fast with the right Eventhouse and query choices.

  6. Exam practice and final review

    1. Exam day: question types, timing and how to think

      Know every question type, manage the clock and use a method that avoids common traps.

    2. Mock exam 1

      Sit a full timed practice exam in the real format and get a score for each skill area.

    3. Mock exam 2

      Sit a second full timed practice exam with new questions and check you're ready.

    4. Final review: every decision on one page

      Review every 'choose between' decision and key fact the exam tests in one place.

Sources (300)

Show

Lessons cite these where they use them.

Questions

What is this course about?
DP-700 is Microsoft's exam for the Fabric Data Engineer Associate certification: ingest, transform, secure, monitor and optimize data in Microsoft Fabric.
What will I be able to do after it?
Pass DP-700 by studying the exact skills Microsoft measures, at the depth the exam needs. Choose the right Fabric store, tool and loading pattern for a workplace scenario. Secure, deploy and orchestrate a Fabric data solution from development to production. Ingest and transform batch and streaming data with pipelines, notebooks, SQL and KQL. Monitor, troubleshoot and optimize Fabric items when something is slow or broken.
Who is it for?
Anyone taking DP-700, including people with no cloud background; module 1 covers the basics and a quick check tells you what to skip. Not for Power BI report design (that's PL-300) or for Azure administration.
How long does it take?
33 lessons in 6 modules, about 13 hours in total. Your progress is saved, so you can take it in short sessions.
Is it free?
Yes. It's free; you sign in so your progress and quiz results are saved.
Where does the content come from?
Lessons cite 300 sources where they use them, including Microsoft Learn: Troubleshoot Spark application code, data, and library errors in Microsoft Fabric; Microsoft Learn: Compare content in different deployment stages; Microsoft Learn: Compacting Delta tables.