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.
Question 30 Which of the following data workloads will utilize a Silver table as its source?
Real Exam
Community
LLeetQuiz
A
A workload that curates data for use in a dashboard
B
A workload that ingests raw data from a streaming source
C
A workload that enriches data by joining multiple data sources
D
A workload that applies business logic to create aggregated metrics
E
A workload that cleanses data by removing malformed records
Explanation:
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.
Comments
Loading comments...