Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Which of the following data workloads will utilize a Gold table as its source?
Real Exam
Community
KKeng
0
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
- Silver layer: Cleaned, validated, and enriched data
- Gold layer: Aggregated, business-ready data for consumption
Gold tables contain aggregated, business-ready data that has been processed for specific use cases like reporting, analytics, and dashboards. Therefore:
-
Option D is correct because querying aggregated data designed to feed into a dashboard is exactly what Gold tables are designed for.
-
Option A (enriching data by parsing timestamps) is typically a Silver layer activity.
-
Option B (aggregating uncleaned data) would use Bronze or Silver as source, not Gold.
-
Option C (cleaning data by removing malformed records) is a Silver layer activity.
-
Option E (ingesting raw data from streaming sources) is a Bronze layer activity.
Gold tables represent the final, refined data layer optimized for business consumption, making them the appropriate source for dashboard queries and reporting workloads.
Comments
Loading comments...