Portfolio ↗

Quiz

2988 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 areas2988 Architecture Fundamentals91 Distributed Systems111 Data Architecture100 Cloud Architecture97 Networking96 API & Integration Architecture97 Reliability & Resilience99 Observability92 Performance & Capacity Engineering100 Security Architecture105 Cost Architecture & FinOps102 Business Architecture103 Architecture Communication102 Enterprise Architecture100 Legacy Modernization102 AI-Era Architecture106 Software Architecture & Engineering93 Architecture Patterns94 Architecture Decision-Making101 The Architect's Meta-Skills102 Delivery & Release Engineering103 Platform Engineering & Developer Experience102 Testing & Quality Architecture102 Data Platform Architecture98 Streaming & Real-Time Data103 Data Governance & Semantics91 Frontend & Experience Architecture101 Edge, Mobile & IoT98 Regulatory & Data Protection Architecture99 Assurance, Audit & Model Risk98
Difficulty Any beginner intermediate advanced

2 questions in Dimensional Modelling.

  1. Dimensional Modelling intermediate Multiple choice

    A BI team replaces a 9-table star schema with a single denormalised table of 240 columns because dashboards were slow and analysts kept joining at the wrong grain. Six months later the table is 4 TB across roughly 3 billion rows, the nightly build takes 5 hours, and correcting one product's category requires a full rebuild. Which property did the flattening actually trade away?

    3 min answer one big tabledenormalisationscdrebuild cost
  2. Dimensional Modelling intermediate

    When is dimensional modelling still the right approach, and what does it cost?

    2 min answer dimensional-modellingstar-schemausabilityperformance