
Answer-first summary for fast verification
Answer: Gold tables are more likely to contain aggregations than Silver tables.
## Explanation In the Databricks Medallion Architecture: **Silver Layer**: Contains cleaned, enriched, and validated data. This layer has data that has been transformed from the raw Bronze layer but is not yet fully optimized for business consumption. **Gold Layer**: Contains highly refined, aggregated, and business-ready data. This layer is optimized for reporting and analytics with: - More transformations applied - Aggregations and summaries - De-normalized data models - Read-optimized structures - Fewer joins needed for queries The key distinction is that Gold tables undergo more transformations and are specifically designed for business consumption, which often involves aggregations, summaries, and de-normalization for performance. While both layers contain valuable and truthful data, the Gold layer is specifically structured for reporting purposes with more transformations including aggregations. **Why other options are incorrect**: - **B**: Both layers contain valuable data - the value is in how it's structured, not the inherent value - **C**: Gold tables contain MORE refined views, not less refined - **D**: Gold tables often contain LESS data due to aggregations and summaries - **E**: Both layers should contain truthful data after cleaning and validation
Author: Keng Suppaseth
Ultimate access to all questions.
No comments yet.
Which of the following describes the relationship between Gold tables and Silver tables?
A
Gold tables are more likely to contain aggregations than Silver tables.
B
Gold tables are more likely to contain valuable data than Silver tables.
C
Gold tables are more likely to contain a less refined view of data than Silver tables.
D
Gold tables are more likely to contain more data than Silver tables.
E
Gold tables are more likely to contain truthful data than Silver tables.