Portfolio ↗

Quiz

2707 questions of the kind that actually get asked — in interviews, in architecture review boards, and by the person who has to run the thing at 3 AM. Every answer states the trade-off rather than the slogan, and says when the obvious choice is the wrong one.

All areas2707 Architecture Fundamentals81 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking86 API & Integration Architecture78 Reliability & Resilience88 Observability81 Performance & Capacity Engineering90 Security Architecture95 Cost Architecture & FinOps92 Business Architecture93 Architecture Communication91 Enterprise Architecture91 Legacy Modernization92 AI-Era Architecture96 Software Architecture & Engineering84 Architecture Patterns84 Architecture Decision-Making91 The Architect's Meta-Skills92 Delivery & Release Engineering93 Platform Engineering & Developer Experience92 Testing & Quality Architecture90 Data Platform Architecture98 Streaming & Real-Time Data93 Data Governance & Semantics91 Frontend & Experience Architecture91 Edge, Mobile & IoT88 Regulatory & Data Protection Architecture90 Assurance, Audit & Model Risk98
Difficulty Any beginner intermediate advanced

6 questions in Transformation Frameworks.

  1. Transformation Frameworks intermediate

    A platform adopts a transformation framework and analysts build hundreds of models. What governance is needed to prevent a tangle?

    2 min answer transformationmodellinggovernancetesting
  2. Transformation Frameworks beginner

    A team runs 40 SQL scripts nightly, numbered 01 through 40 and executed in order by a shell script. Someone proposes adopting a transformation framework. A senior analyst pushes back - the scripts already run in the right order, so what does a framework actually add? What is the honest answer, and when is the analyst right?

    3 min answer dbtdependency graphenvironmentstesting
  3. Transformation Frameworks advanced

    A transformation project has grown to 600 models with chains twelve deep. A change at the base has an unknowable blast radius. What do you do?

    2 min answer data-platformtransformationmodellingmaintainability
  4. Transformation Frameworks advanced

    A transformation project has grown to hundreds of models with a build taking hours. What structural problems produce that, and what fixes them?

    2 min answer dbt-labsdagincrementalmodularity
  5. Transformation Frameworks intermediate

    Review this transformation project. 300 models are all views with no materialisations and chains up to 11 deep. Every model has not-null and unique tests on every column - about 2400 tests. CI runs a full build plus the whole test suite on every pull request - 70 minutes. Each developer has a personal schema. What would you remove, what would you change and what would you leave alone?

    3 min answer dbtviewsmaterialisationtesting
  6. Transformation Frameworks advanced

    Your transformation project has 2,400 models. A full build takes six hours and one change rebuilds half the graph. How did this happen and what do you do?

    2 min answer eltmodellingmaintainability