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

5 questions in Reverse ETL.

  1. Reverse ETL intermediate

    A company wants warehouse data pushed back into operational systems. What are the design considerations, and what should not go through this path?

    2 min answer udaanreverse-etloperationalfreshness
  2. Reverse ETL intermediate

    A platform pushes warehouse-derived data back into operational systems. What are the risks, and what must be designed?

    2 min answer reverse-etloperational-datafreshnessidempotency
  3. Reverse ETL advanced

    A warehouse table now feeds the CRM through reverse ETL. It breaks, and the analytics team and the CRM team each say it is the other's problem. How do you resolve it?

    1 min answer data-platformreverse-etlownershipoperations
  4. Reverse ETL advanced

    At 01:50 an upstream system renames a column and the nightly customer model's join silently yields 4,000 rows instead of 1.2 million. Every test on that model is a not-null check on columns that survived, so the model passes. At 02:30 reverse ETL syncs it to the CRM. By 09:15 sales reports that lifecycle stage and account owner are blank on more than a million accounts and overnight campaigns fired against the wrong segment. Nothing errored. What failed, and which design decision made it possible?

    3 min answer reverse etlfull syncblast radiusvolume tests
  5. Reverse ETL intermediate

    Marketing wants warehouse segments pushed into the campaign tool hourly. What do you require before agreeing?

    2 min answer integrationgovernanceoperations