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
4 questions in Slowly Changing Dimensions.
-
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 -
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 -
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 -
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