Portfolio ↗

Quiz

2777 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 areas2777 Architecture Fundamentals81 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking86 API & Integration Architecture87 Reliability & Resilience99 Observability92 Performance & Capacity Engineering90 Security Architecture95 Cost Architecture & FinOps92 Business Architecture93 Architecture Communication91 Enterprise Architecture100 Legacy Modernization92 AI-Era Architecture96 Software Architecture & Engineering93 Architecture Patterns84 Architecture Decision-Making91 The Architect's Meta-Skills92 Delivery & Release Engineering93 Platform Engineering & Developer Experience92 Testing & Quality Architecture102 Data Platform Architecture98 Streaming & Real-Time Data93 Data Governance & Semantics91 Frontend & Experience Architecture91 Edge, Mobile & IoT88 Regulatory & Data Protection Architecture99 Assurance, Audit & Model Risk98
Difficulty Any beginner intermediate advanced

2777 questions.

  1. Data Platform Tenancy advanced

    A departing tenant's contract requires deletion within 30 days. Their rows sit in a shared 40 TB events table in an open table format - partitioned by event_date with tenant_id as one column of 60, snapshot retention 90 days, compaction weekly. An engineer runs a DELETE for that tenant_id. What happens next, and what is the 30-day clock actually measuring?

    3 min answer datadogtenancydeletionretention
  2. Data Platform Tenancy advanced

    A product-analytics platform serves many customers' data on shared infrastructure. What isolation is required at the storage and query layers?

    2 min answer posthogtenancyisolationquotas
  3. Data Platform Tenancy advanced

    Pinterest described in 2015 how every object it stores carries a 64-bit identifier with the shard number packed into the high bits, so any object routes to its database without a lookup. Your analytics platform holds 40 TB of event tables for 900 internal tenants keyed by a random UUID, and an engineer proposes adopting the same trick for the warehouse. What does packing the tenant into the key actually buy on the analytical side, and where would copying Pinterest be a mistake?

    3 min answer pinteresttenancykey designpartitioning
  4. Data Platform Tenancy advanced

    Your multi-tenant analytics platform stores all tenants in shared tables with a `tenant_id` column. What is the risk and how do you close it?

    2 min answer tenancysecurityisolation
  5. Data Products intermediate

    A marketplace publishes a merchant sales data product with a 15-minute freshness SLO to roughly 200000 merchant consumers. A flash sale of the kind Flipkart runs takes order volume to about 20 times normal for six hours. No pipeline fails and no alert fires. What happens to the data product over those six hours and what stops it?

    3 min answer data productsfreshness slopeak loaddegradation
  6. Data Products intermediate

    A ride-hailing and delivery platform operating across eight South-East Asian markets, of the kind Grab operates, has one internal trips_enriched table that 40 teams already read directly. Leadership wants it published as a data product with an owner, a freshness SLO and per-market residency rules. You cannot break the 40 readers and there is no cutover weekend available. Give the sequence.

    3 min answer grabdata-productsresidencyconsumer-migration
  7. Data Products intermediate

    A team's dataset is heavily used, so the platform group proposes promoting it to a data product with an owner, a published interface and an SLO. The team is willing. What have they actually taken on, and when does that bill arrive?

    2 min answer data-productsownershipslodeprecation
  8. Data Products advanced

    Design a data product exposing merchant sales analytics to hundreds of thousands of independent merchants on a commerce platform. What makes it a product rather than a table?

    1 min answer data-productsownershipcontractsmulti-tenancy
  9. Data Quality Dimensions advanced

    A marketplace's seller metrics look wrong but every pipeline succeeded and every test passed. How do you diagnose it?

    1 min answer data-qualitydiagnosiscompletenesssemantics
  10. Data Quality Dimensions intermediate Multiple choice

    A nightly freshness check alerts when a table's daily row count deviates more than 20% from the previous day. Volume follows a weekly pattern: weekends run about 40% below weekdays. Roughly how many alerts a month does this produce before anything is actually wrong, and what should replace it?

    2 min answer data-qualityalertingseasonalitythresholds
  11. Data Quality Dimensions beginner Multiple choice

    A supplier table has 12% of rows with a blank tax identifier and 3% where the identifier is present but does not match the registry. Both are called data quality issues in the same report. Why does separating them change who is asked to fix them?

    2 min answer data qualitycompletenessaccuracyownership
  12. Data Quality Dimensions intermediate

    A team wants to measure data quality. Which dimensions matter, and which tests actually catch problems?

    2 min answer dbt-labsdata-qualitytestsfreshness