Databricks Data Engineer Associate Question 20
Single answerYou are implementing a data pipeline in Databricks. Your team has ingested raw clickstream data into a bronze table. After cleaning and enriching the data, it is stored in a silver table. Finally, the data is aggregated to provide business insights and stored in a gold table. Which of the following workloads is most likely to use the gold table as a source?
- A
Real-time ingestion of raw streaming data
- B
Generating business intelligence reports for executive decision-making
- C
Data cleaning and deduplication tasks
- D
Staging data for further enrichment
Show answer and explanation
Correct answer: B
Explanation
Gold tables are intended for business-ready, aggregated, or summarized data that supports decision-making and reporting workloads. In contrast, bronze tables are used for raw data ingestion and silver tables are used for intermediate processing tasks such as cleaning and enrichment.
- A. Incorrect.
Real-time ingestion of raw streaming data typically uses a bronze table as its source, as bronze tables store raw, unprocessed data.
- B. Correct.
Gold tables are designed for serving business-ready data, making them the appropriate source for generating business intelligence reports.
- C. Incorrect.
Data cleaning and deduplication tasks are generally performed on silver tables, which contain data that is partially processed and ready for refinement.
- D. Incorrect.
Staging data for further enrichment is usually performed using silver tables, as they provide a clean and enriched dataset ready for transformation.