Delta tables, loading patterns and T-SQL in Fabric

DP-700 · Ingest and transform data · Updated

Load and maintain Delta tables with MERGE, SCD patterns, OPTIMIZE, VACUUM and V-Order, and use GROUP BY ROLLUP in the warehouse.

This lesson is part of full DP-700 access

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

In this lesson
  • Loading patterns
  • Slowly changing dimensions
  • Table maintenance
  • Warehouse T-SQL
  • Star schema
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-700 course outline

All 7 lessons · Course overview
  1. Workspace roles and item-level access in FabricImplement and manage an analytics solution Free
  2. Git integration and deployment pipelinesImplement and manage an analytics solution Free
  3. Data pipelines, notebooks and orchestrationIngest and transform data Full access
  4. Eventstreams, windowing and Real-Time IntelligenceIngest and transform data Full access
  5. Delta tables, loading patterns and T-SQL in FabricIngest and transform data Full access
  6. Monitoring runs with Monitoring hub and alertsMonitor and optimize an analytics solution Full access
  7. Spark settings, high concurrency and performance tuningMonitor and optimize an analytics solution Full access