Assess knowledge of lakehouse architectures, Delta tables, and orchestration patterns feeding MMM.
Lakehouse unifies data warehouse and lake by storing files in open formats like ______.
HTML
Parquet
JPEG
CSV
Columnar Parquet supports efficient analytics while residing on low‑cost object storage.
Delta Lake provides ACID transactions via ______ logs.
dns
cookie
transaction
pixel
Commit logs track file versions enabling reliable upserts for MMM fact tables.
Medallion architecture stages data as Bronze (raw), Silver (clean), and ______.
Platinum
Iron
Lead
Gold
Gold tables contain aggregated spend/KPI feeds ready for modelling dashboards.
Streaming inserts with exactly‑once semantics ensure spend feeds for MMM remain ______ consistent.
dirty
read‑uncommitted
append‑only
eventual
Reliable streaming avoids duplicate rows that inflate historical spend.
Lakehouse query engines like DuckDB allow analysts to run SQL directly on ______ files.
ico
Parquet
docx
mp3
On‑the‑fly analytics removes ETL overhead, accelerating exploratory KPI checks.
2025 Databricks Lakehouse Federation lets MMM read Snowflake tables via ______ layer.
CSV export
ODBC DSN
FTP
Unity Catalog
Central governance layer secures cross‑platform data access with one set of permissions.
Partitioning by week and channel optimises scan for MMM, reducing ______ IO.
disk
cookie
dns
font
Engine prunes irrelevant partitions, speeding queries and lowering cost.
Snapshot tables with slowly changing dimensions track retro changes like ______ recoding.
CDN
pixel
UTM
SSL
Historical correction of mis‑tagged source/medium should propagate to MMM via snapshots.
Airflow DAGs orchestrate daily ingestion; task failure alerts via ______ notify data team.
dns
CRT
Slack
cookie
Immediate alerts reduce data gaps before model refresh.
Lakehouse design keeps raw logs immutable; transformations create new versions enabling ______ rollback.
pixel
time‑travel
cookie
ttl
If an ETL bug surfaces, analysts query prior snapshot to redo processing.
Starter
Review the basics.
Solid
Nice work—refine the details.
Expert!
Exceptional command of the topic.
