Portfolio ↗

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
Difficulty Any beginner intermediate advanced

5 questions in Partitioning & Sharding.

  1. Partitioning & Sharding advanced Multiple choice

    A collaboration product is sharding its database. Options are hash of message ID, hash of user ID, or workspace ID. Which and why?

    2 min answer shardingslackboundariesisolation
  2. Partitioning & Sharding advanced

    A messaging platform stores messages partitioned by channel identifier. Some channels are enormously more active than others. Fix the partitioning.

    2 min answer discordpartitioningskewcompound-key
  3. Partitioning & Sharding advanced

    A multi-tenant SaaS platform runs thousands of tenants on a shared relational database, but a handful of tenants now hold most of the data. Should it use shared tables, tenant partitioning, dedicated databases, sharding or a hybrid?

    2 min answer freshworksmulti-tenancyisolationsharding
  4. Partitioning & Sharding advanced

    A workspace product stores every document as a tree of small "block" rows in one enormous table. Growth makes the table unmanageable. Design the sharding strategy - and identify the choice that is effectively irreversible.

    2 min answer shardingshard-keyworkspacesnotion
  5. Partitioning & Sharding advanced

    Your geospatial data is partitioned by city. One city generates 40% of all traffic. What are your options?

    2 min answer uberskewpartitioningscaling