Practice Lab
Solve real problems, not reading assignments
Every lab has a business scenario, constraints, starter data, validation tests, cost notes and a best-practice review.
Incremental CDC into Delta with late-arriving data
A retailer's ERP exports order changes every 15 minutes. Updates and deletes arrive out of order, and finance reports double-counted revenue last quarter.
SCD Type 2 conformed customer dimension
Sales and Service use different customer IDs. Leadership needs historically accurate revenue by customer segment.
Diagnose a skewed Spark join
A nightly job joining clickstream to products went from 12 to 95 minutes after a marketing campaign.
Design Unity Catalog permissions for a data mesh
Three domains (Sales, Finance, Supply) share one metastore. Auditors flagged broad ALL PRIVILEGES grants.
RLS on a Direct Lake semantic model
Regional managers must only see their region, but the model must stay in Direct Lake mode.
Retry, recovery and alerting for pipelines
A source API intermittently returns 429s. Failed runs leave partial data and nobody notices until morning.