Databricks Certified Data Engineer - Associate

Explanation

In the Databricks Lakehouse medallion architecture:

• Bronze tables contain raw, unprocessed data from source systems
• Silver tables contain cleaned, validated, and enriched data ready for business use
• Gold tables contain aggregated, summarized data for reporting and analytics

A Silver table serves as the source for workloads that:

• Curate data for dashboards and BI tools
• Prepare data for downstream analytics
• Provide clean, reliable data for business applications

Option A is incorrect because this is a data cleaning and preparation task. It typically happens when creating a Silver table. The source for this job would be a Bronze table.

Option B is incorrect because ingesting raw data from streaming sources would use Bronze tables as the source.

Option C is incorrect because joining multiple data sources typically happens during the Silver layer processing, not using Silver as a source.

Option D is correct because D. This is the definitive process for creating a Gold table. The source for this aggregation job is the cleaned, reliable data in the Silver table.

Option E is incorrect because cleansing data by removing malformed records is typically done during the Bronze to Silver transformation process.