A data engineering team is implementing Medallion Architecture on Databricks. A business analyst asks which layer of the architecture is most appropriate to apply star or snowflake dimensional modeling for direct use by BI tools and reporting dashboards. Which layer should the analyst be directed to?
Show answer & explanation
Correct answer: E
WHY E: In the Medallion Architecture, the Gold layer is where data is transformed into curated, aggregated, business-ready form. Dimensional modeling patterns are applied there: star schemas (fact plus denormalized dimension tables) or snowflake schemas (fact plus normalized dimension hierarchies) that support BI tools, dashboards, and reporting. WHY NOT A: The Bronze layer stores raw, unprocessed data exactly as received from source systems, including schema imperfections, duplicates, and nulls. It does not apply dimensional modeling. WHY NOT B: The Silver layer applies cleansing, deduplication, and schema enforcement, but it produces cleansed operational entities, not business-aggregated dimensional models optimized for BI. WHY NOT C: The Medallion Architecture reserves each layer for a specific transformation purpose; Bronze and Silver are not designed for dimensional modeling, which belongs in Gold. WHY NOT D: The Medallion Architecture does define progressive transformation conventions for each layer, including Gold as the home of consumption-ready dimensional models; it is not purely a scheduling or orchestration abstraction.