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

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 Storage Layout & Partitioning.

  1. Storage Layout & Partitioning intermediate Multiple choice

    A 4 TB events table serves three query patterns: 80% ask for one tenant over the last 7 days, 15% look up a single event by id, and 5% scan one product across all history. The table currently has no partitioning. Which layout should the team adopt?

    2 min answer partitioningclusteringcardinalitylayout
  2. Storage Layout & Partitioning intermediate

    A 6 TB events table is partitioned by `customer_id`. Queries are slow and the storage layer complains. What is wrong?

    2 min answer partitioningperformancedesign
  3. Storage Layout & Partitioning beginner Multiple choice

    A new engineer asks why the 8 TB events table in the lakehouse has no index on customer_id when the same column is indexed in the operational Postgres the data came from. What is the actual reason?

    2 min answer partitioningcolumnarpruningparquet
  4. Storage Layout & Partitioning advanced

    A platform's analytical queries scan far more data than they need. Which storage layout decisions fix this?

    2 min answer partitioningclusteringpruninglayout
  5. Storage Layout & Partitioning advanced

    An analytical query scans far more data than it needs. Before adding compute, what layout decisions should be examined?

    2 min answer meeshopartitioningclusteringfile-size
The practice set

2908 interview questions, 6040 flashcards, 2325 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