Portfolio ↗

Quiz

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

51 questions in Data Platform Architecture.

  1. Analytics Cost Control advanced

    An analytics platform's query costs are growing faster than its data. What are the drivers and controls?

    2 min answer analytics-costbytes-scannedmaterialisationgovernance
  2. Batch Orchestration advanced

    A data platform's batch jobs have complex interdependencies and a failure early in the night cascades. What orchestration properties matter?

    2 min answer orchestrationdependenciesidempotencybackfill
  3. Batch Orchestration advanced

    On the last Sunday in October a UK data platform's 01:30 daily job ran twice and duplicated rows in a revenue table. On the last Sunday in March the same job did not run at all. The scheduler is configured in local time. What failed, and what is the structural fix?

    3 min answer schedulingdaylight savingidempotencyutc
  4. Batch Orchestration advanced

    The batch orchestrator's scheduler process dies at 02:40 with about 30 tasks already running on workers. It is restarted at 03:00. The nightly load includes a MERGE into a revenue table and a push to a payments vendor. What happens between 02:40 and 03:15?

    2 min answer orchestrationidempotencyat-least-oncezombie-tasks
  5. CDC Pipeline Design advanced

    A CDC pipeline feeding your warehouse falls three hours behind during a source system's batch job, and the source's transaction log retention is 24 hours. What is the risk and what do you change?

    2 min answer cdcstreamingretentionoperations
  6. CDC Pipeline Design advanced

    A content platform's search index lags the source by up to 30 minutes. Product wants it under 10 seconds. What do you assess?

    2 min answer searchcdcfreshnesscost
  7. CDC Pipeline Design advanced

    A logistics platform feeds its warehouse from operational databases by change data capture. What must the pipeline design handle?

    2 min answer delhiverycdcschemaordering
  8. CDC Pipeline Design advanced

    A platform builds change data capture from its operational databases. What is the failure that turns an analytics problem into a production incident?

    2 min answer cdcbackpressureretentionschema
  9. Data Platform Architecture advanced

    A mobility platform's data team is overwhelmed by requests and every new dataset requires their involvement. What is the structural problem?

    2 min answer data-platformself-serviceownershipbottleneck
  10. Data Platform Architecture advanced

    You are the first data platform engineer at a 200-person company. The CFO's board pack is assembled in a spreadsheet from three CSV exports, the product team queries a read replica directly, and two teams have started separate warehouse trials. Your manager asks what you will do in the first quarter. Walk me through how you would answer.

    2 min answer interviewplatformprioritisationstakeholders
  11. Data Platform Tenancy advanced

    A data platform serves many internal teams with very different data volumes and sensitivity. How should tenancy be structured?

    2 min answer data-tenancyisolationaccess-controlcost
  12. 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