Delta tables, Spark and Power Query transformations

DP-600 · Prepare data · Updated

Maintain Delta tables with OPTIMIZE and VACUUM, write PySpark loads, use T-SQL window functions and the right Power Query M functions.

This lesson is part of full DP-600 access

The first 2 DP-600 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-600 question bank.

In this lesson
  • Delta table maintenance
  • PySpark loading
  • T-SQL patterns in a warehouse
  • Power Query M
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-600 course outline

All 6 lessons · Course overview
  1. Git integration and deployment pipelines in FabricMaintain a data analytics solution Free
  2. Workspace roles, XMLA endpoint and monitoring in FabricMaintain a data analytics solution Free
  3. Lakehouse or warehouse and loading data in FabricPrepare data Full access
  4. Delta tables, Spark and Power Query transformationsPrepare data Full access
  5. Direct Lake and storage modes for semantic modelsImplement and manage semantic models Full access
  6. Model design, DAX and dynamic formattingImplement and manage semantic models Full access