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

Difficulty Any beginner intermediate advanced

5 questions in Indexing.

Quiz

A query filters on `lower(email)` and there is an index on `email`. The query is slow and the plan shows a sequential scan. Why, and what are the fixes?

A search platform receives continuous document updates while users expect newly published content to appear quickly. How should indexing pipelines, replicas, refresh intervals, cache invalidation and query serving be separated?

A source-code platform must make code across millions of repositories searchable, where repositories differ enormously in size and activity. Which indexing decisions dominate, and what makes this different from indexing documents?

A table has 14 indexes and writes have become slow. How do you decide which to remove?

Prices change continuously based on demand and dates. Search must filter and sort by price over millions of listings. How?