Certified Data Engineer Associate Exam - Question 29

Bronze tables are basically raw ingested data, often with schema borrowed from the original data source or table. Correct answer is E.

Option E

Ans : E The Bronze layer is where we land all the data from external source systems. The table structures in this layer correspond to the source system table structures "as-is," along with any additional metadata columns that capture the load date/time, process ID, etc. The focus in this layer is quick Change Data Capture and the ability to provide an historical archive of source (cold storage), data lineage, auditability, reprocessing if needed without rereading the data from the source system. https://www.databricks.com/glossary/medallion-architecture#:~:text=Bronze%20layer%20%28raw%20data%29

E option

E. Bronze tables contain raw data with a schema applied. In a typical data processing pipeline following a "Bronze-Silver-Gold" data lakehouse architecture, Bronze tables are the initial stage where raw data is ingested and transformed into a structured format with a schema applied. The schema provides structure and meaning to the raw data, making it more usable and accessible for downstream processing. Therefore, Bronze tables contain the raw data but in a structured and schema-enforced format, which makes them distinct from the unprocessed, unstructured raw data files.

E is the right answer. Bronze data are simply a more structured (in terms of schema) version of raw data to be found in the "landing area".

Correct is E

E Bronze tables are the foundation of the Delta Lake data lake architecture. They are created from raw data files and contain a schema that describes the data. This makes it easy to query and analyze the data in Bronze tables. Raw data files, on the other hand, do not have a schema applied. This means that it can be difficult to query and analyze the data in raw data files. Option A: Bronze tables typically contain more data than raw data files, because they include the schema. Option B: There is no indication that Bronze tables contain more truthful data than raw data. Option C: Bronze tables can contain aggregates, but they do not have to. Option D: Bronze tables typically contain a more refined view of data than raw data, because they include the schema.

Ans: E https://www.databricks.com/glossary/medallion-architecture#:~:text=Bronze%20layer%20%28raw%20data%29

E is correct

still i am not sure about the schema as i thought that correct types are usually defined in silver while in bronze are all strings