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 architecture, data typically flows through three layers:
- Bronze Layer: Raw, unprocessed data ingested from source systems
- Silver Layer: Cleaned, validated, and enriched data
- Gold Layer: Aggregated, business-ready data optimized for consumption
Gold tables contain aggregated, business-ready data that is optimized for consumption by end-users, dashboards, and reporting tools. They represent the final, refined data layer where data is:
- Aggregated to business-level metrics
- Optimized for query performance
- Structured for specific business use cases
- Ready for consumption by BI tools and dashboards
Analysis of each option:
- A: This describes data enrichment (parsing timestamps), which typically happens in the Silver layer, not using Gold tables as source.
- B: This describes aggregating uncleaned data, which would happen before the Gold layer (likely in Silver or Bronze).
- C: This describes data cleaning (removing malformed records), which is a Silver layer activity.
- D: CORRECT - Querying aggregated data for dashboards is exactly what Gold tables are designed for. Gold tables contain aggregated, business-ready data optimized for consumption by dashboards and reporting tools.
- E: This describes data ingestion from streaming sources, which is a Bronze layer activity.
Therefore, only option D correctly describes a workload that would utilize a Gold table as its source.
Comments
Loading comments...