Which of the following data workloads will utilize a Gold table as its source?

The Medallion Architecture organizes data into Bronze (raw), Silver (cleansed/enriched), and Gold (aggregated/business-level) tables. Gold tables contain highly refined and aggregated data, specifically prepared for business intelligence (BI), reporting, and analytics. A job that queries this aggregated data to populate a dashboard is a primary consumer of Gold tables, thus using them as its source. This aligns with the purpose of the Gold layer, which is to provide clean, business-centric data products for final consumption.

A. A job that enriches data by parsing its timestamps into a human-readable format: This is a typical enrichment task performed when moving data from the Bronze to the Silver layer, not consuming from the Gold layer.
B. A job that aggregates uncleaned data to create standard summary statistics: This job uses uncleaned (Bronze) data as its source. Gold tables are built from cleaned, validated Silver data, not the other way around.
C. A job that cleans data by removing malformatted records: This is a data cleaning process, which is characteristic of the workload that creates Silver tables from Bronze tables.
E. A job that ingests raw data from a streaming source into the Lakehouse: This describes the initial ingestion step that populates Bronze tables, the first layer of the Medallion Architecture.

1. Databricks Documentation

"What is the medallion lakehouse architecture?":

Reference for Correct Answer (D): In the section "Gold tables (curated business-level tables)

" the documentation states

"This layer provides data for analytics

machine learning

and production applications." Dashboards are a primary form of analytics application.

Reference for Incorrect Options (A

C

E): The documentation describes the Bronze layer as the target for raw data ingestion (E) and the Silver layer as the result of cleaning and enrichment (A

C) from the Bronze layer. The document states

"Data from the bronze layer is matched

merged

conformed

and cleansed to create the silver layer."