Quiz
2627 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 areas2627
Architecture Fundamentals81
Distributed Systems101
Data Architecture90
Cloud Architecture77
Networking86
API & Integration Architecture78
Reliability & Resilience88
Observability81
Performance & Capacity Engineering90
Security Architecture85
Cost Architecture & FinOps82
Business Architecture93
Architecture Communication91
Enterprise Architecture91
Legacy Modernization82
AI-Era Architecture86
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 Architecture88
Streaming & Real-Time Data93
Data Governance & Semantics81
Frontend & Experience Architecture91
Edge, Mobile & IoT88
Regulatory & Data Protection Architecture90
Assurance, Audit & Model Risk88
3 questions in Query Optimisation.
-
Query Optimisation advanced
A query that ran in 50ms for two years now takes 90 seconds. Nothing was deployed and the data volume grew normally. What happened?
2 min answer plannerstatisticsplan-flipdiagnosis -
Query Optimisation intermediate Multiple choice
An endpoint's p99 is 4 seconds. The database's slow query log is empty and CPU is low. What is happening?
2 min answer n-plus-oneperformancedebugginggithub -
Query Optimisation advanced
In a multi-tenant platform where every tenant's data shares the same physical tables and tenants differ in size by orders of magnitude, why do query plans that are optimal for one tenant become pathological for another - and what is the fix?
2 min answer query-optimisationmulti-tenancystatisticsplan-caching