Answer-first summary for fast verification
Answer: The query is enabling a transition from the Silver layer to a Gold table.
This Structured Streaming query is designed to generate business-level aggregates from the cleaned orders data located in the silver table `cleanedOrders`, and then load these aggregates into the gold table `aggregatedOrders`. This process exemplifies a transition from the Silver layer to the Gold table within a multi-hop architecture. Reference: [Medallion Architecture](https://www.databricks.com/glossary/medallion-architecture).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the context of a multi-hop architecture, what is the primary function of the following Structured Streaming query?
.table("cleanedOrders")
.groupBy("productCategory")
.agg(sum("totalWithTax"))
.writeStream
.option("checkpointLocation", checkpointPath)
.outputMode("complete")
.table("aggregatedOrders")```
.table("cleanedOrders")
.groupBy("productCategory")
.agg(sum("totalWithTax"))
.writeStream
.option("checkpointLocation", checkpointPath)
.outputMode("complete")
.table("aggregatedOrders")```
A
The query is executing raw data ingestion into a Bronze table.
B
The query is facilitating a transition from a Bronze table to a Silver table.
C
The query is enabling a transition from the Silver layer to a Gold table.
D
The query is managing data transfer from a Gold table into a production application.
E
The query is conducting data quality checks before the Silver layer.
No comments yet.