Answer-first summary for fast verification
Answer: A job that queries aggregated data designed to feed into a dashboard
**Explanation:** In the Databricks Lakehouse medallion architecture: 1. **Bronze tables** contain raw, unprocessed data 2. **Silver tables** contain cleaned, validated, and enriched data 3. **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.
Author: Keng Suppaseth
Ultimate access to all questions.
Which of the following data workloads will utilize a Gold table as its source?
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
No comments yet.