Quiz

2948 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 areas2948 Architecture Fundamentals91 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking96 API & Integration Architecture87 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

5 questions in Materialized Views.

Quiz

A discussion platform precomputes ranked feeds as materialised views. What does this buy, and what are the failure modes?

A read-heavy query is too expensive to compute on demand. Compare a database materialized view, an application-maintained read model and a stream-processed view, and describe how each handles staleness and rebuild.

A ride-hailing platform maintains a materialised view of driver availability by geographic cell. What are the design decisions, and what breaks?

A tenant-scoped dashboard query over an 80 million row orders table takes 9 seconds. It filters one tenant id and the last 30 days and returns 40 rows. The only index is on created_at. A proposal is to add a nightly materialised view. Which change should come first?

Your social feed precomputes each user's timeline when someone they follow posts. An account with 40 million followers joins. What breaks and how do you fix it?