Skip to content
⌗ Praveen T N Architecture Practice
Editorial Quiz Flashcards Terminology Deliverables Digs Feed
Portfolio ↗
Today Editorial Quiz Flashcards Terminology Deliverables Identify the deliverable Digs Feed Search Back to portfolio ↗
Architecture/Quiz

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

3 questions in Query Optimisation.

  1. 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
  2. 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
  3. 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
The practice set

2627 interview questions, 5674 flashcards, 2185 glossary entries and 55 worked deliverables across 30 areas of the solution architecture curriculum. Free, no sign-up, no paywall.

Sections Editorial Quiz Flashcards Terminology Deliverables Use cases Digs Identify the deliverable Architecture feed RSS
Elsewhere Portfolio AI & ML Library LinkedIn Buy me a coffee Contact Privacy policy Terms of use

Written and maintained by Praveen T N.

© 2026 Praveen T N