Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Which of the following data workloads will utilize a Gold table as its source?
Real Exam
Community
KKeng
A
A job that enriches data by parsing its timestamps into a human-readable format
B
A job that aggregates uncleaned data to create standard summary statistics
C
A job that cleans data by removing malformed records
D
A job that queries aggregated data designed to feed into a dashboard
E
A job that ingests raw data from a streaming source into the Lakehouse
Explanation:
Explanation:
In the Databricks Lakehouse medallion architecture:
- Bronze tables contain raw, unprocessed data
- Silver tables contain cleaned, validated, and enriched data
- Gold tables contain aggregated, business-level data ready for consumption
Gold tables are specifically designed for:
- Business intelligence and reporting
- Dashboards and visualizations
- Aggregated metrics and KPIs
- Production-ready analytics
Option D correctly describes a job that queries aggregated data designed to feed into a dashboard, which aligns with the purpose of Gold tables. The other options describe workloads that would use different layers:
- A & C: Typically use Silver tables (data cleaning and enrichment)
- B: Would use Bronze or Silver tables (uncleaned data)
- E: Would use Bronze tables (raw data ingestion)
The medallion architecture ensures data quality improves as it moves from Bronze → Silver → Gold, with Gold tables being the final, production-ready layer for business consumption.
Comments
Loading comments...