Which of the following queries is performing a streaming hop from raw data to a Bronze table?
Which of the following queries is performing a streaming hop from raw data to a Bronze table?
This query is performing a streaming hop from raw data to a Bronze table because it reads from a raw data source using 'readStream' and writes to a table using 'writeStream'. The Bronze table in a medallion architecture typically contains raw data, and the query must involve streaming data in real-time, which is indicated by 'readStream' and 'writeStream' in the query.
answer E: Raw to Bronze is simply an integration of source data in the lakehouse without any schema needed nor extra operationss (e;g filtering, aggregation, joins etc..) Please refer to this Medaillon Architecture article https://www.databricks.com/glossary/medallion-architecture
Yes E is correct. But There are filtering or aggregation in silver layer . We need to check if it have readstream and writestream
https://docs.databricks.com/en/lakehouse/medallion.html#ingest-raw-data-to-the-bronze-layer
sourcename is “rawSalesLocation” (bronze tables contain raw data) and code includes “readStream” to indicate that it is a streaming hop
Answer is B
Answer should be E. Filtering and cleaning usually happens from bronze to silver layer
I think we should have read stream and writestream that should the important point
E is ok , all others are incorrect