Portfolio ↗

Quiz

2908 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 areas2908 Architecture Fundamentals91 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking86 API & Integration Architecture87 Reliability & Resilience99 Observability92 Performance & Capacity Engineering100 Security Architecture95 Cost Architecture & FinOps102 Business Architecture103 Architecture Communication102 Enterprise Architecture100 Legacy Modernization92 AI-Era Architecture96 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

5 questions in Slowly Changing Dimensions.

  1. Slowly Changing Dimensions intermediate

    A "customers by segment" dashboard tile reports 104,300 where the customer table holds 100,000 rows. Revenue on the same dashboard is also about 4% high. The join looks correct, the pipeline is green, and re-running changes nothing. What is happening?

    3 min answer scd2joinsfan-outdbt tests
  2. Slowly Changing Dimensions advanced

    A customer dimension has always been Type 1 - attributes overwritten in place. Compliance now requires every order to report the segment and region the customer had at the time of the order, three years back. 140 reports read the dimension and 2.1 billion fact rows join it on the natural customer key. Sequence the conversion under live reporting.

    3 min answer scdtype-2migrationsurrogate-keys
  3. Slowly Changing Dimensions intermediate

    A customer's attribute changes. Which slowly-changing-dimension approach should be used, and what decides it?

    2 min answer scdhistorypoint-in-timereporting
  4. Slowly Changing Dimensions intermediate

    A retail platform's product attributes change over time, and historical reports must reflect the values as they were. What modelling approach handles this?

    2 min answer nykaascdhistorydimensional
  5. Slowly Changing Dimensions intermediate Multiple choice

    The business asks why the regional sales report changed for a period that closed six months ago. What happened, and what is the fix?

    2 min answer dimensional-modellinghistorycorrectness