Skip to content
DP-700 Fabric Engineer Hub

Fabric Medallion Architecture Visualizer

🏗️ Fabric Medallion Architecture & Workloads

Inspect the end-to-end data lifecycle in Microsoft Fabric across Lakehouses, Warehouses, Delta Lake tables, and Real-Time Intelligence.

Architecture Visualizer

Microsoft Fabric End-to-End Medallion Architecture

Click a stage to inspect workloads & code
Cleaned & Conformed

3. Silver (Enriched Lakehouse)

Cleaned, deduplicated, standardized, joined, and schema-validated enterprise dataset. Serves as the trusted single source of truth.

Core Fabric Items & Workloads

Fabric Notebooks (PySpark / Delta Lake Python API)
Delta Liquid Clustering (ALTER TABLE CLUSTER BY)
Delta Maintenance (OPTIMIZE, V-ORDER, VACUUM)
Lakehouse SQL Analytics Endpoint (Read-Only T-SQL)

DP-700 Exam Best Practices

✓Apply Liquid Clustering on multi-column query filter keys (e.g. customer_id, order_date)
✓Enable V-ORDER Parquet sorting during OPTIMIZE for VertiPaq memory acceleration
✓Perform periodic VACUUM with safe retention period (>= 7 days) to preserve Delta time travel
Delta Liquid Clustering & Optimization
sql
-- Enable Liquid Clustering on multi-column query keys
ALTER TABLE silver_sales
CLUSTER BY (CustomerID, OrderDate, StoreRegion);

-- Run file compaction with VertiPaq V-Order layout
OPTIMIZE silver_sales;

-- Safely remove historical unreferenced parquet files
VACUUM silver_sales RETAIN 168 HOURS;