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

4 questions in Slowly Changing Dimensions.

  1. Slowly Changing Dimensions intermediate

    A "customers by segment" dashboard tile reports 104,300 where the customer table holds 100,000 rows. Revenue on the same dashboard is also about 4% high. The join looks correct, the pipeline is green, and re-running changes nothing. What is happening?

    3 min answer scd2joinsfan-outdbt tests
  2. Slowly Changing Dimensions intermediate

    A customer's attribute changes. Which slowly-changing-dimension approach should be used, and what decides it?

    2 min answer scdhistorypoint-in-timereporting
  3. Slowly Changing Dimensions intermediate

    A retail platform's product attributes change over time, and historical reports must reflect the values as they were. What modelling approach handles this?

    2 min answer nykaascdhistorydimensional
  4. Slowly Changing Dimensions intermediate Multiple choice

    The business asks why the regional sales report changed for a period that closed six months ago. What happened, and what is the fix?

    2 min answer dimensional-modellinghistorycorrectness
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