Question

A data engineering team ingests raw JSON clickstream events directly into a Delta table named events_bronze, preserving the exact source data including malformed records and duplicates. Downstream, a business analytics team needs cleaned, deduplicated, and validated event records with standardized schema for building aggregated dashboards. According to the medallion architecture, which layer should the team create to hold the cleaned and conformed data before it is aggregated for the dashboards?

Accepted Answer

A silver layer table that applies cleaning, deduplication, and schema enforcement to the bronze data

Answer

A second bronze table that stores another raw copy of the events with no transformations

Answer

A gold layer table containing the final business-level aggregations consumed by dashboards

Answer

A platinum layer table that combines raw and aggregated data in a single location