#The One-Page Cheatsheet
The page to read in the car park. Nothing new here β only what you most want loaded when you walk in.
#Posture
You are a consultant meeting a client, not a candidate being examined. Ask before you answer. Decide, then say what it costs. Be the most honest person in the room.
#The four frameworks
Design β CLAIM: Context (ask 3β5 questions) β Levers (the 2β3 decisions that decide it)
β Architecture (draw) β Implications (what you gave up) β Measure (how you'd know).
Debug β Symptom β Scope β Evidence β Hypothesis β Test β Fix β Prevent. Never propose a fix before naming the evidence.
Behavioural β STAR-L: keep S and T short, most airtime on A ("I decidedβ¦"), R has a number, L is honest.
Objections β Feel β Felt β Found β Fact. Concede what's true first. The fact is mandatory.
#Opening moves
- Any design question: "Before I design anything β what's the freshness requirement, who operates this in a year, and what's the regulatory position?"
- Any performance question: "First: what changed? Then: where is the time going?"
- Any comparison question: concede what's genuinely true about the competitor, name the dimension that decides it for this customer, recommend, offer coexistence.
- Anything you don't know: "I don't know that specifically. Here's how I'd reason about it, and here's how I'd verify." Then reason well and move on.
#The numbers you'll reach for
| Skew investigation threshold | max/median task duration β³ 5Γ |
| Target file size | ~128 MBβ1 GB (auto-tuned) |
| Shuffle partition target | Low hundreds of MB |
| Partition a table only if | β³1 TB, and partitions β³1 GB |
| Z-order columns | β€3β4; prefer liquid clustering |
| Delta log retention / deleted-file retention | 30 days / 7 days (defaults) |
| Auto-termination | 30β60 min max on interactive |
| Quick cost win from config alone | Typically 15β30% |
State these as heuristics. False precision is worse than "order of magnitude, roughly X".
#Six things that signal real experience
- "Before I tune anything β what changed?"
- "Max versus median task time in the slowest stage."
- "I'd pin the data with time travel and re-run, to separate a data problem from a code problem."
- "Adding nodes to a skewed job makes it more expensive and exactly as slow."
- "The fix is one thing; the monitor that catches it next time is the deliverable."
- "Governance that can be bypassed isn't governance."
#Six things not to do
- Design before asking.
- List features instead of naming a decision and its trade-off.
- Bluff. (The only disqualifying failure.)
- Use old product names β DLT, Workflows, online tables.
- Defend a wrong answer. Say "you're right, I had that backwards" and move on.
- Talk for eleven minutes without a breath.
#Currency, in one line each
Lakehouse//RT / Reyden β millisecond SQL on governed Delta/Iceberg, no serving-store copy. Beta, read-only. Lakebase / LTAP β serverless Postgres on lake storage; operational writes landing directly in open columnar formats, removing the CDC pipeline. LTAP announced. Iceberg v3 GA β deletion vectors, row lineage, VARIANT; Delta and Iceberg can share Parquet files. Unity AI Gateway β runtime governance of models/agents/tools: hard spend caps, routing, action policies, guardrails, tracing. Unity Catalog Metrics / Domains / Glossary β the governed semantic layer; the fix for inconsistent KPIs and the substrate agents need. Omnigent β open-source meta-harness above agent frameworks. Genie One / Ontology β agentic analytics with a continuously-built enterprise context layer.
Say them in service of an architecture point. Never recite the list.
#The three sentences to have ready
Your thesis on AI:
"Everyone has the same models. The differentiator is governed context and runtime control β which is a data architecture problem, not a model problem."
Your thesis on cost:
"I don't want to make the platform cheaper, I want to make it attributable. Once spend is tagged to product teams, they optimise without anyone policing them."
Your thesis on the role:
"The job is making architecture repeatable across engagements, so the tenth customer gets the benefit of the first nine β while staying close enough to the metal to be credible when something is on fire."
#Last things
- Ask your questions. Having none is a scored failure.
- Close with: "Is there anything about my background that gives you pause? I'd rather address it now."
- Breathe. You have done the work.