Answer-first summary for fast verification
Answer: Create multiple smaller bronze tables, each dedicated to a specific data source or topic.
Creating multiple smaller bronze tables, each dedicated to a specific data source or topic, is a best practice for productionalizing streaming workloads. This approach enhances manageability, scalability, and reliability by reducing the complexity of each table, facilitating targeted data processing, and minimizing the risk of data corruption or performance bottlenecks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Design a strategy for creating a multiplex bronze table to avoid common pitfalls when trying to productionalize streaming workloads. What are the key considerations and best practices to ensure scalability and reliability?
A
Use a single large bronze table to consolidate all streaming data.
B
Create multiple smaller bronze tables, each dedicated to a specific data source or topic.
C
Avoid partitioning and use a flat schema for simplicity.
D
Periodically truncate and reload the bronze table to manage data growth.
No comments yet.