Answer-first summary for fast verification
Answer: Include an event type column to differentiate and facilitate efficient filtering of data sources.
In a multiplex (or 'munged') bronze architecture, multiple data sources or event types are ingested into a single consolidated Delta table. A key best practice is to include an `event_type` or `source` column. This allows downstream Silver-layer streaming jobs to efficiently filter the stream for specific records using standard predicates, ensuring that processing logic remains decoupled and scalable.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When architecting a multiplex bronze table for ingestion in a streaming workload, which design choice is considered a key best practice?
A
Implement a fixed, rigid schema to accommodate all incoming event types.
B
Avoid partitioning the table entirely to minimize metadata overhead and complexity.
C
Include an event type column to differentiate and facilitate efficient filtering of data sources.
D
Store all associated metadata columns in a separate lookup table to keep the bronze layer lean.