Portfolio ↗

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 Workload Isolation.

  1. Workload Isolation advanced

    A data platform's ad-hoc queries, scheduled pipelines and machine-learning training compete for the same capacity. How should they be isolated?

    2 min answer workload-isolationcontentionprioritybackfill
  2. Workload Isolation intermediate

    A data platform's interactive queries become unpredictable whenever a large pipeline runs. What is the fix, and what remains shared?

    2 min answer sharechatisolationcomputeclasses
  3. Workload Isolation intermediate Multiple choice

    A lakehouse platform runs interactive BI on its own compute cluster and pipelines on another, and both are sized comfortably. Every Tuesday and Wednesday queries against the ten largest tables run 3 to 6 times slower on both clusters at once, then recover by Thursday. Table maintenance - compaction and snapshot expiry - is submitted as low-priority work on the pipeline cluster. Which change fixes it?

    3 min answer compactionmaintenanceisolationsmall files
  4. Workload Isolation advanced

    An analytics platform separates storage from compute so many teams can query the same data. How should result caching, per-team compute isolation, concurrency scaling and cost attribution be designed — and what workloads defeat the cache?

    3 min answer snowflakestorage-computecachingisolation
  5. Workload Isolation intermediate

    Every morning at 09:00 executive dashboards are slow. Investigation shows a data scientist's exploratory query. How do you fix this permanently?

    1 min answer isolationperformanceplatform