System design interview question
"Design a multi-tenant issue tracker. Every customer configures their own issue types, custom fields, and workflows — one team's 'Bug' has different fields and states from another's. Then they query and report across all of it. A hundred thousand customer organizations."
schema flexibility at scale, which is a genuinely hard and under-appreciated problem. Every tenant effectively defines their own data model, so you cannot use a fixed schema — but the obvious flexible alternatives (a JSON blob, or an entity-attribute-value table) each break down for querying and reporting. The distinguishing content is how you get both per-tenant flexibility and efficient search.
On Practick another engineer interviews you live for 60 minutes on a question from this bank. They have the full interviewer guide beside the call: the answers to your clarifying questions, the numbers to hand out, a ladder of follow-ups and a scoring rubric. You get the model solution once the session settles. It is free: interview someone for an hour and you have earned your own.
Book a free mock interviewAll 132 system design interview questions
System design mock interviews · DSA interview questions · Free mock interview practice · Browse interviewers · Sign in