Understand CDC with SQL Server and Debezium: snapshots, ordering, idempotency, checkpoints and exactly-once caveats. Includes a reference architecture and recovery checklist.

Design Fabric Real-Time Intelligence with Eventstreams, Eventhouse and KQL. Plan event contracts, schema changes, late data, retention and measurable response latency.

Build Fabric governance with ownership, Purview policies, lineage and effective access checks. Includes a responsibility matrix and audit-evidence checklist.

Plan Fabric CI/CD with Git, separate workspaces and deployment gates. Includes environment settings, a release manifest, verification and data-aware rollback.

Choose Fabric mirroring, pipelines or shortcuts by source support, freshness and operational constraints. Includes architecture paths, a selection matrix and recovery checks.

Compare Direct Lake, Import and DirectQuery with a reproducible benchmark method. Review freshness, fallback, concurrency, memory and total reporting cost.

Understand OneLake shortcuts, effective identities, cross-cloud access and caching. Includes a configuration contract, lifecycle guidance and troubleshooting checks.

Compare Fabric Data Factory and Azure Data Factory by connectors, identities, orchestration and cost. Choose a migration path with compatibility and recovery checks.

Plan a Synapse-to-Fabric migration by workload. Inventory pipelines, Spark, SQL and reporting dependencies, then manage risks, validation, cutover and rollback.

Compare Fabric Lakehouse and Warehouse by write paths, SQL transactions, Spark, governance and performance. Includes a decision matrix and practical architecture scenarios.