Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?
Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?
The correct option is the one that involves aggregation, as the transition from a Silver table to a Gold table typically includes some form of data summarization or aggregation to create clean, refined data sets for analysis. Option E appears to demonstrate this process by involving group by operations and using the 'complete' output mode to replace the entire table data rather than appending it. This method aligns with the purpose of a Gold table in a data lake architecture, which is to store aggregated and cleaned data.
E is the correct answer.
Option E
E option
E is correct as it includes group by as well by store.
E as we're doing an aggregation and we're rewriting the whole table and not just appending.
The best practice is to use "Complete" as output mode instead of "append" when working with aggregated tables. Since gold layer is work final aggregated tables, the only option with output mode as complete is option E.
E is the right answer. The "gold layer" is used to store aggregated clean data, E is the only answer in wich aggregation is performed.
E is correct
Answer shoiuld be A , for writestream data should be stream only and not static
that's a good point but i would say that A is performing a raw data ingestion into bronze
E - Aggregations are performed from silver to gold