Which of the following statements regarding the relationship between Silver tables and Bronze tables is always true?

In a medallion architecture, a common data design pattern for lakehouses, data flows from Bronze

to Silver to Gold layer tables, with each layer progressively improving the structure and quality of

data. Bronze tables store raw data ingested from various sources, while Silver tables apply minimal

transformations and cleansing to create an enterprise view of the data. Silver tables can also join and

enrich data from different Bronze tables to provide a more complete and consistent view of the data.

Therefore, option D is the correct answer, as Silver tables contain a more refined and cleaner view of

data than Bronze tables. Option A is incorrect, as it is the opposite of the correct answer. Option B is

incorrect, as Silver tables do not necessarily contain aggregates, but can also store detailed records.

Option C is incorrect, as Silver tables may contain less data than Bronze tables, depending on the

transformations and cleansing applied. Option E is incorrect, as Silver tables may contain more data

than Bronze tables, depending on the joins and enrichments applied. Reference: What is a Medallion

Architecture?, Transforming Bronze Tables in Silver Tables, What is the medallion lakehouse

architecture?