
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
Start here: cloud and data basics
- 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.
- 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.
- 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.
- 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.
- The three languages: SQL, PySpark and KQL side by side
Read and write the basic queries the exam shows in SQL, PySpark and KQL.
- Getting data in: the map of Fabric tools
Know every way data gets into Fabric and the one question that picks each tool.
- Start here: the exam, the plan and what you already know
Store, ingest and transform batch data (exam area 2, 30-35%)
- Choosing a data store and a transformation tool
Pick Lakehouse, Warehouse or Eventhouse, and Dataflow Gen2, notebook or T-SQL, from a scenario.
- 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.
- 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.
- Transform with PySpark and SQL: join, denormalize, aggregate
Shape raw tables into analytics tables with joins, grouping and aggregations.
- Messy data: duplicates, missing values and late arrivals
Find and fix duplicate, missing and late-arriving data before it reaches reports.
- Full and incremental loads, and loading a star schema
Design full and incremental loads and prepare data for fact and dimension tables.
- Choosing a data store and a transformation tool
Orchestrate and stream (exam areas 1 and 2)
- Pipeline or notebook? Choosing how to orchestrate
Pick between a pipeline and a notebook for a job and combine them when needed.
- Schedules and event-based triggers
Run pipelines and notebooks on a schedule or when something happens.
- Parameters and dynamic expressions
Make one pipeline or notebook handle many tables with parameters and expressions.
- Streaming in Fabric: Eventstreams, Spark streaming and KQL
Pick the right streaming engine and load streaming data into Fabric.
- KQL and windowing functions for real-time data
Query streaming data with KQL and group events into time windows.
- Pipeline or notebook? Choosing how to orchestrate
Set up and secure a Fabric solution (exam area 1, 30-35%)
- Workspace settings: Spark, domains, OneLake and data workflows
Configure the workspace settings the exam asks about and know what each one changes.
- Version control with Git and database projects
Connect a workspace to Git, commit and update items, and use database projects for warehouses.
- Deployment pipelines: development, test and production
Move content between stages with deployment pipelines and change settings per stage.
- Who can see what: workspace roles and item permissions
Grant the least access a person needs with workspace roles and item-level sharing.
- Fine-grained security: rows, columns, objects, files and masking
Restrict which rows and columns people see and mask sensitive values in Fabric.
- Governance: sensitivity labels and endorsement
Label sensitive items and mark trusted ones so people find the right data.
- Workspace settings: Spark, domains, OneLake and data workflows
Monitor, fix and optimize (exam area 3, 30-35%)
- Monitoring hub, alerts and Activator
Watch ingestion, transformations and refreshes and get alerted when something breaks.
- Fixing errors in pipelines, dataflows and notebooks
Read the error, find the cause and fix failing pipelines, dataflows and notebooks.
- Fixing errors in Eventhouse, Eventstream and T-SQL
Diagnose real-time and SQL errors and know where each one is reported.
- Optimize lakehouse tables: V-Order, OPTIMIZE, VACUUM and partitions
Keep Delta tables fast and small with V-Order, compaction, vacuum and sensible partitions.
- Optimize Spark, pipelines and warehouses
Speed up Spark jobs, pipelines and warehouse queries with the settings the exam names.
- Optimize eventstreams, eventhouses and queries
Keep real-time pipelines and queries fast with the right Eventhouse and query choices.
- Monitoring hub, alerts and Activator
Exam practice and final review
- Exam day: question types, timing and how to think
Know every question type, manage the clock and use a method that avoids common traps.
- Mock exam 1
Sit a full timed practice exam in the real format and get a score for each skill area.
- Mock exam 2
Sit a second full timed practice exam with new questions and check you're ready.
- Final review: every decision on one page
Review every 'choose between' decision and key fact the exam tests in one place.
- Exam day: question types, timing and how to think
Sources (300)
ShowHide
Lessons cite these where they use them.
- 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
- Microsoft Learn: Turn on OneLake availability for an eventhouse
- Microsoft Learn: What is Mirroring in Fabric?
- Microsoft Learn: Dimensional modeling in Microsoft Fabric Warehouse: Dimension tables
- Microsoft Learn: What is Data Factory in Microsoft Fabric?
- Microsoft Learn: Permission model
- Microsoft Learn: What is an on-premises data gateway?
- Microsoft Learn: What is Fabric Activator?
- Microsoft Learn: Job admission in Apache Spark for Microsoft Fabric
- Microsoft Learn: Development process using branch workspace
- Microsoft Learn: Fabric notebooks troubleshooting guide
- Microsoft Learn: Incrementally load data from Data Warehouse to Lakehouse
- Microsoft Learn: Microsoft Fabric decision guide: choose a data store
- Microsoft Learn: OneLake shortcut security
- Microsoft Learn: OneLake shortcuts
- Microsoft Learn: Create deployment rules
- Microsoft Learn: Monitor the status and performance of an eventstream
- Microsoft Learn: Understand Direct Lake query performance
- Microsoft Learn: Delta Lake schema evolution
- Microsoft Learn: DataFrame class (PySpark reference)
- Microsoft Learn: Explore file storage
- Microsoft Learn: What is Microsoft Entra?
- Microsoft Learn: Enable item certification
- Microsoft Learn: Describe Software as a Service
- Microsoft Learn: summarize operator
- Microsoft Learn: Access on-premises data sources in Data Factory for Microsoft Fabric
- Microsoft Learn: Troubleshoot pipelines for Data Factory in Microsoft Fabric
- Microsoft Learn: Query data in a KQL queryset
- Microsoft Learn: Transactions in Fabric Data Warehouse
- Microsoft Learn: Sensitivity label downstream inheritance
- Microsoft Learn: Native execution engine for Fabric Data Engineering
- Microsoft Learn: Direct Lake overview
- Microsoft Learn: Configure lakehouse in a copy activity
- Microsoft Learn: Pause and resume your Fabric capacity
- Microsoft Learn: Basic concepts in Git integration
- Microsoft Learn: Upsert into a Delta Lake table using merge
- Microsoft Learn: Microsoft Fabric decision guide: Choose a data movement strategy
- Microsoft Learn: Microsoft Fabric decision guide: copy activity, Copy job, dataflow, Eventstream, or Spark
- Microsoft Learn: Unify data with OneLake shortcuts and mirroring
- Microsoft Learn: Caching policy (hot and cold cache)
- Microsoft Learn: fillna (PySpark reference)
- Microsoft Learn: Warehouse definition
- Microsoft Learn: Use the Fail activity to cause pipeline execution to fail with a customized error message and error code
- Microsoft Learn: Apache Airflow Job workspace settings
- Microsoft Learn: Choose the best Fabric CI/CD workflow option for you
- Microsoft Learn: Explore analytical data processing
- Microsoft Learn: OneLake diagnostics
- Microsoft Learn: SQL to Kusto Query Language cheat sheet
- Microsoft Learn: Microsoft Fabric decision guide: Choose a data integration strategy
- Microsoft Learn: Best practices for Structured Streaming
- Microsoft Learn: Transform data by running a notebook
- Microsoft Learn: Troubleshoot Spark memory and performance issues
- Microsoft Learn: join operator
- Microsoft Learn: Get data into Microsoft Fabric
- Microsoft Learn: KQL quick reference
- Microsoft Learn: Stateful processing with Structured Streaming
- Microsoft Learn: Overview of Apache Spark compute in Microsoft Fabric
- Microsoft Fabric Community: Data Days | Certification Vouchers
- Microsoft Learn: Configure settings for a Fabric eventstream
- Microsoft Learn: Best practices for OneLake security
- Microsoft Learn: What is an Apache Airflow job?
- Microsoft Learn: Run, schedule, or use events to trigger a pipeline
- Microsoft Learn: Spark compute configuration settings in Fabric environments
- Microsoft Learn: Quickstart: Create a Copy job
- Microsoft Learn: Fabric domains
- Microsoft Learn: Change data policies
- Microsoft Learn: High concurrency mode in Apache Spark for Fabric
- Microsoft Learn: Column-level security in Fabric Data Warehouse
- Microsoft Learn: Ingest Delta Lake tables with T-SQL
- Microsoft Learn: What is the Microsoft Fabric Capacity Metrics app?
- Microsoft Learn: dropDuplicates (PySpark reference)
- Microsoft Learn: Tutorial: Learn common operators
- Microsoft Learn: Row-level security syntax reference
- Microsoft Learn: Choose an analytical data store in Microsoft Fabric
- Microsoft Learn: Explore Fabric workspace item events in Fabric Real-Time hub
- Microsoft Learn: On-premises data gateway FAQ
- Microsoft Learn: Vouchers and redeeming discounts
- Microsoft Learn: innerunique join
- Microsoft Learn: Power BI implementation planning: Tenant setup
- Microsoft Learn: Quickstart: Create your first pipeline to copy data
- Microsoft Learn: Result set caching
- Microsoft Learn: How to copy data using copy activity
- Microsoft Learn: Develop warehouse projects in Visual Studio Code
- Microsoft Learn: Troubleshoot on-premises data gateways
- Microsoft Learn: Troubleshoot lakehouse issues for Microsoft Fabric Data Engineering
- Microsoft Learn: Expressions and functions for Data Factory in Microsoft Fabric
- Microsoft Learn: Ingest data into your Warehouse using Transact-SQL
- Microsoft Learn: SQL database source control integration in Microsoft Fabric
- Microsoft Learn: Activity retries in Microsoft Fabric Data Factory
- Datakuity: Tips for the DP-700 exam (candidate report)
- Microsoft Learn: Set up job alerts in the Monitor hub (preview)
- Microsoft Learn: Endorsement overview
- Microsoft Learn: Permissions: GRANT, DENY, REVOKE
- Microsoft Learn: Development and Monitoring (Spark best practices)
- Microsoft Learn: Overview of Structured Streaming
- Microsoft Learn: Query Delta tables with time travel
- Microsoft Learn: Monitor job runs in the Monitor hub
- Microsoft Learn: Lakehouse tutorial: Prepare and transform data in the lakehouse
- Microsoft Learn: Lakehouse git integration and deployment pipelines
- Microsoft Learn: What is cloud computing
- Microsoft Learn: Find and explore data in the OneLake catalog
- Microsoft Learn: Add a sample data source to an eventstream
- Microsoft Learn: Conflict resolution
- Microsoft Learn: Apache Airflow compute in Fabric
- Microsoft Learn: Create an eventhouse
- Microsoft Learn: Process event data by using the event processing editor
- Microsoft Learn: Give users access to workspaces
- Microsoft Learn: Query the warehouse or SQL analytics endpoint
- Microsoft Learn: What is Real-Time Intelligence?
- Microsoft Learn: Row-level security in Fabric Data Warehouse
- Microsoft Learn: Apply sensitivity labels to Fabric items
- Microsoft Learn: Frequently asked questions (FAQs) about online proctored exams
- Microsoft Learn: Exam and Applied Skills assessment lab retake policies
- Microsoft Learn: Workspaces in Microsoft Fabric and Power BI
- Microsoft Learn: Microsoft Fabric Eventstream for Azure Event Hubs and Stream Analytics users
- Microsoft Learn: Dataflow Gen2 data destinations and managed settings
- Microsoft Learn: Pause and resume in Fabric Data Warehouse
- Microsoft Learn: Z-Order for Delta tables
- Microsoft Learn: Delimited text format in Data Factory in Microsoft Fabric
- Microsoft Learn: Update policy overview
- Microsoft Learn: Development and deployment overview (Fabric Data Warehouse)
- Microsoft Learn: What is a variable library?
- Microsoft Learn: Data Factory limitations overview
- Microsoft Learn: Data refresh in Power BI
- Microsoft Learn: Microsoft Fabric security fundamentals
- Microsoft Learn: Dataflow refresh
- Microsoft Learn: Troubleshoot refresh scenarios
- Microsoft Learn: Endorse Fabric and Power BI items
- Microsoft Learn: Troubleshoot query blocking in Fabric Data Warehouse
- Microsoft Learn: Understand batch and stream processing
- Microsoft Learn: Spark monitoring and performance optimization best practices
- Microsoft Learn: What is an Apache Spark job definition?
- Microsoft Learn: Configure Multi-Geo support for Fabric
- Microsoft Learn: Partitioning for Delta tables
- Microsoft Learn: Governance overview and guidance
- Microsoft Learn: Best practices for Kusto Query Language queries
- Microsoft Learn: Lakehouse and Delta Lake tables
- Microsoft Learn: How to implement dynamic data masking in Fabric Data Warehouse
- Microsoft Learn: Introduction to Azure and Fabric events
- Microsoft Learn: Tutorial: Join data from multiple tables
- Microsoft Learn: Microsoft Fabric end-to-end security scenario
- Microsoft Learn: Shared responsibility in the cloud
- Microsoft Learn: Read data secured with OneLake security
- Microsoft Learn: JSON mapping
- Microsoft Learn: String operators
- Microsoft Learn: About online exams with Pearson VUE
- Microsoft Learn: Understand medallion architecture for Fabric with OneLake
- Microsoft Learn: Evaluate and optimize your Microsoft Fabric capacity
- Microsoft Learn: Use the Lookup activity to look up data from a data source
- Microsoft Learn: OneLake catalog overview
- Microsoft Learn: Manage Apache Spark libraries in Microsoft Fabric
- Microsoft Learn: Hopping Window
- Microsoft Learn: Copy activity performance with SQL databases
- Microsoft Learn: Configure a warehouse in a copy activity
- Microsoft Learn: Exam and assessment lab security policy
- Microsoft Learn: Introduction to Stream Analytics windowing functions
- Microsoft Learn: Roles in workspaces in Microsoft Fabric
- Microsoft Learn: Microsoft Certified: Fabric Data Engineer Associate
- Microsoft Learn: Get started with Git integration
- Microsoft Learn: Low shuffle merge optimization on Delta tables
- Microsoft Learn: Delta Lake overview
- Microsoft Learn: Data streaming into a lakehouse with Spark
- Microsoft Learn: Govern and manage your Fabric data estate with the OneLake catalog
- Microsoft Learn: What is OneLake?
- Microsoft Learn: Enable workspace monitoring in Microsoft Fabric (pipelines)
- Microsoft Learn: Introduction to deployment pipelines
- Microsoft Learn: What are SQL database projects?
- Microsoft Learn: row_number
- Microsoft Learn: Eventhouse overview
- Microsoft Learn: Monitor eventstream for stopped events
- Microsoft Learn: Configure high concurrency mode for Fabric notebooks
- Microsoft Learn: How OneLake security controls data access
- Microsoft Learn: Fabric terminology
- Microsoft Learn: Get streaming data into lakehouse and access with SQL analytics endpoint
- Microsoft Learn: Share your data and manage permissions
- Microsoft Learn: Develop, execute, and manage Microsoft Fabric notebooks
- Microsoft Learn: OneLake security for SQL analytics endpoints
- Microsoft Learn: Spark errors overview in Microsoft Fabric
- Microsoft Learn: Deploy content using Deployment pipelines
- Microsoft Learn: DENY (Transact-SQL)
- Microsoft Learn: Data Engineering workspace administration settings in Microsoft Fabric
- Microsoft Learn: Use a notebook to load data into your lakehouse
- Microsoft Learn: Study Guide for Exam DP-700
- Microsoft Learn: Tutorial: Orchestrate Fabric jobs with Job events
- Microsoft Learn: On-premises and virtual network data gateway considerations for data destinations in Dataflow Gen2
- Microsoft Learn: Intelligent cache in Microsoft Fabric
- Microsoft Learn: NotebookUtils notebook run and orchestration
- Microsoft Learn: View refresh history and monitor your dataflows
- Microsoft Learn: How to read and write data with Pandas in Microsoft Fabric
- Microsoft Learn: Dimensional modeling in Microsoft Fabric Warehouse: Load tables
- Microsoft Learn: Tutorial: Route data using table update policies
- Microsoft Learn: Configure high concurrency mode for Fabric notebooks in pipelines
- Microsoft Learn: Find your Fabric home region
- Microsoft Learn: Register and schedule an exam
- Microsoft Learn: Window class
- Microsoft Learn: Explore transactional data processing
- Microsoft Learn: Transform data with a ForEach activity
- Microsoft Learn: Migrate workspace libraries and Spark properties to a default environment
- Microsoft Learn: Prepare and transform data in Microsoft Fabric
- Microsoft Learn: What is workspace monitoring (preview)?
- Microsoft Learn: Run Delta table maintenance in lakehouse
- Microsoft Learn: Troubleshooting dataflow issues: Connection to the data source
- Microsoft Learn: Cross-workload table maintenance and optimization in Microsoft Fabric
- Microsoft Learn: What is a virtual network (VNet) data gateway?
- Microsoft Learn: Exam duration and exam experience
- Microsoft Learn: Variable library integration with pipelines
- Microsoft Learn: Tutorial: Application lifecycle management in Fabric
- Microsoft Learn: Get started with deployment pipelines
- Microsoft Learn: What is Microsoft Fabric Git integration?
- Microsoft Learn: Create alerts for pipeline runs
- Microsoft Learn: How lakehouse sharing works
- Microsoft Learn: Configure starter pools in Microsoft Fabric
- Microsoft Learn: What is Dataflow Gen2?
- Microsoft Learn: NotebookUtils (former MSSparkUtils) for Fabric
- Microsoft Learn: Create an eventstream in Microsoft Fabric
- Microsoft Learn: Activity overview
- Microsoft Learn: Table, column, and row-level security in OneLake
- Microsoft Learn: Git integration tenant settings
- Microsoft Learn: Data security in OneLake
- Microsoft Learn: Ingestion mappings
- Microsoft Learn: Copy activity performance and scalability guide
- Microsoft Learn: PySpark basics
- Microsoft Learn: Open mirroring in Microsoft Fabric
- Microsoft Learn: Ingest from warehouse tables and mirrored databases with T-SQL
- Microsoft Learn: Add an Eventhouse destination to an eventstream
- Microsoft Learn: What is the Monitor hub?
- Microsoft Learn: Use query labels in Fabric Data Warehouse
- Microsoft Learn: Microsoft Fabric decision guide: Choose between Warehouse and Lakehouse
- Microsoft Learn: Quickstart: Get data into OneLake
- Microsoft Learn: Pipeline overview
- Microsoft Learn: Git integration for Fabric warehouse development
- Microsoft Learn: The deployment pipelines process
- Microsoft Learn: Dynamic data masking in Fabric Data Warehouse
- Microsoft Learn: Tune the size of Delta table data files
- Microsoft Learn: What is Copy job in Data Factory for Microsoft Fabric?
- Microsoft Learn: Renew your Microsoft Certification
- Microsoft Learn: Introduction to Fabric Real-Time hub
- Microsoft Learn: Windowing functions (Azure Stream Analytics and Fabric Eventstream)
- Microsoft Learn: Understand Microsoft Fabric licenses and capacity
- Microsoft Learn: .show ingestion failures command
- Microsoft Learn: Dimensional modeling in Fabric Data Warehouse
- Microsoft Learn: Troubleshoot Spark session, configuration, and platform errors
- Microsoft Learn: SQL granular permissions in Microsoft Fabric
- Microsoft Learn: Roles in workspaces in Power BI
- Microsoft Learn: Job scheduler in Microsoft Fabric
- Microsoft Learn: Lakehouse tutorial: Create a Fabric workspace
- Microsoft Learn: Incremental copy in Copy job
- Microsoft Learn: What is a lakehouse in Microsoft Fabric?
- Microsoft Learn: Create and manage OneLake security roles
- Microsoft Learn: Enable master data endorsement
- Microsoft Learn: bin()
- Microsoft Learn: Information protection in Microsoft Fabric
- Microsoft Learn: Query Insights in Fabric Data Warehouse
- Microsoft Learn: Exam scoring and score reports
- Microsoft Learn: Use the Office 365 Outlook activity to send an email with Outlook
- Microsoft Learn: Get data from Eventstream
- Microsoft Learn: Explore Job events in Fabric Real-Time hub
- Microsoft Learn: .show streamingingestion failures command
- Microsoft Learn: Capacity consumption for Microsoft Fabric eventstreams
- Microsoft Learn: Dimensional modeling in Microsoft Fabric Warehouse: Fact tables
- Microsoft Learn: Sensitivity label inheritance upon update and relationship changes in Microsoft Fabric
- Microsoft Learn: Build event-driven Pipelines with OneLake events and Azure Blob Storage events
- Microsoft Learn: Security in Microsoft Fabric
- Microsoft Learn: What is Microsoft Fabric?
- Microsoft Learn: Kusto Query Language overview
- Apache Spark documentation: Generic Load/Save Functions
- Microsoft Learn: Analytical and aggregate functions in Fabric Data Warehouse
- Microsoft Learn: Create a same-tenant OneLake shortcut
- Microsoft Learn: Materialized views
- Microsoft Learn: Monitor pipeline runs in the legacy Monitoring hub
- Microsoft Learn: Troubleshoot Spark SQL and schema errors
- Microsoft Learn: Optimize Delta Lake tables with V-order
- Microsoft Learn: Parameters for Data Factory in Microsoft Fabric
- Microsoft Learn: Create, configure, and use an environment in Fabric
- Microsoft Learn: Tutorial: Explore and transform sample bike-sharing data with Eventstream for KQL Database integration
- Microsoft Learn: Tutorial: Use variable libraries to customize and share item configurations
- Microsoft Learn: Pipeline canvas in Fabric Data Factory
- Microsoft Learn: Explore OneLake events in Fabric Real-Time hub
- Microsoft Learn: Overview of Microsoft Fabric eventstreams
- Microsoft Learn: How to use Git integration for warehouse development and deployment
- Microsoft Learn: Tutorial: Use aggregation functions
- Microsoft Learn: Performance guidelines in Fabric Data Warehouse
- Microsoft Learn: Fabric Activator rules
- Microsoft Learn: Use the Set Variable activity in Fabric
- Microsoft Learn: Create a lakehouse in Microsoft Fabric
- Microsoft Learn: Fabric CI/CD concepts and best practices
- Microsoft Learn: Materialized views use cases
- Microsoft Learn: Secure your Fabric Data Warehouse
- Microsoft Learn: VACUUM Delta tables
- Microsoft Learn: Work with data in a Spark dataframe
- Microsoft Learn: Identify data formats
- Microsoft Learn: Share items in Microsoft Fabric
- Microsoft Learn: Create custom Spark pools in Microsoft Fabric
- Microsoft Learn: Delta Lake table format interoperability
- Microsoft Learn: OneLake tenant settings
- Microsoft Learn: Microsoft Entra service description
- Microsoft Learn: T-SQL surface area in Fabric Data Warehouse
- Microsoft Learn: Create and edit materialized views
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.