Correct Answer: B. Use streaming tables for bronze quality data and streaming live tables for silver and gold quality data.
Explanation:
This is the recommended best practice because:
- Streaming tables are ideal for bronze quality data (raw data ingestion) as they provide low-latency ingestion capabilities for streaming data sources
- Streaming live tables are better suited for silver and gold quality data as they support more complex transformations, data quality constraints, and incremental processing pipelines
This approach ensures:
- Efficient raw data ingestion with minimal latency
- Proper data quality enforcement and transformations in later stages
- Scalable and maintainable streaming data pipelines
- Clear separation between ingestion and transformation layers