Courses / HEC NSCT – National Skill Competency Test: Complete Preparation for Computing Graduates
11.1 How to Solve Scenario-Based MCQs
Integrated Scenarios – Multi-Area Case MCQs · 25 min read · 12 MCQs to check yourself
How to answer system design questions (Exponent)
A 5-step method
- Read the question first, then the scenario – you then know what to look for.
- Underline the constraint words: cheapest, fastest, most secure, first, best, least downtime, millions of users, sensitive data.
- Name the area being tested (Is it a DB question? A security question? A process question?).
- Eliminate extremes and irrelevant options – an answer can be true in general but not fix this problem.
- Pick the option that solves the root cause, not just the symptom (e.g. add an index rather than "buy a faster server").
Typical pairs to remember
| Situation in the scenario | Usually points to |
|---|---|
| Slow search on a large table | Index on the searched column |
| Same data in many rows, update anomalies | Normalisation |
| Traffic spikes (sales, results day) | Auto-scaling + load balancer, caching/CDN |
| User input placed in SQL | Parameterised queries |
| Passwords stored | bcrypt/Argon2 with salt |
| Requirements keep changing | Agile/Scrum, iterative delivery |
| Life-critical, fixed requirements | Formal process, V-model, heavy testing |
| Money transfer must be all-or-nothing | Transaction (ACID) |
| Many readers, few writes, global users | Read replicas, CDN, cache |
| Model great on training data, poor on new data | Overfitting → regularisation, more data, cross-validation |
| Rare positive class (fraud, disease) | Recall/precision/F1, not accuracy |
| Need offices to share resources securely | VPN / private network, subnetting |
This lesson ends with a quiz of 12 MCQs. Open the lesson on PrepOasis to take it and save your progress.
Previous: Area 10 Review, Checklist and Area Test · Next: 11.2 Scenarios: Startups, Web Products and E-commerce