Component Inventory

The following table provides a complete inventory of all components in the What-If Solution Architecture, their technology classification, and their functional role.

Component	Technology	Role / Function
What-If UI	Front-end	Web-based analyst portal for scenario definition and result review.
Scenario DB	Fabric SQL	Relational store for scenario parameters, run history, and audit records.
Data Platform (Source)	Microsoft Fabric OneLake	Source of truth for in-force policy data; read by Notebooks as the policy population.
Transformation	Spark Notebook	Filters policy population by scenario parameters; outputs What-If Policy Set. Transforms policy records into Rating Engine XML documents. Captures and parses raw Rating Engine responses into structured records.
Spark Distributed Computing	Apache Spark on Fabric	Parallel execution engine for payload preparation and mass rating calls.
Rating Engine	External Service	Third-party or internal rating system that computes premium from XML inputs.
Rating Output	Delta Table / OneLake	Canonical analytical table of re-rated premium results per policy per scenario.
Summary View	Delta Table / OneLake	Aggregated KPI layer consumed by Power BI.
Power BI	Microsoft Power BI	Self-service dashboards and scheduled reports for pricing and actuarial teams.
Orchestration	Microsoft Fabric Pipelines	Pipeline scheduler governing batch runs; Scenario runs.