Answer-first summary for fast verification
Answer: Incorporate an event type or source identifier column to distinguish between different data streams.
In a multiplexed bronze table (often referred to as a landing zone or ingest table for multiple sources), it is essential to include an event type or source identifier column. This allows downstream silver-level processing to efficiently filter and route data based on its origin or schema without scanning irrelevant records.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When architecting a multiplex bronze table for streaming workloads in Databricks, which of the following is considered a key best practice?
A
Use a fixed, rigid schema to handle all incoming event types.
B
Incorporate an event type or source identifier column to distinguish between different data streams.
C
Store metadata columns in a separate lookup table to minimize row size.
D
Disable partitioning entirely to minimize management overhead.