A data analyst is working in an organization that utilizes a multi-hop, medallion architecture.

Option C is the correct answer because it creates a new aggregated table, store_sales, from the existing cleaned/refined table cleaned_transactions. In a medallion architecture, a table such as cleaned_transactions represents a Silver-layer table because it contains cleaned or validated transaction-level data. The query then creates store_sales by grouping by store_id and calculating SUM(sales), which is an aggregation suitable for analytics and reporting. That is exactly the Silver-to-Gold hop.

Option A creates cleaned_transactions from transactions, so it is moving toward a cleaned Silver table, not creating a Gold table. Option B creates transactions from raw_transactions, which is closer to a raw-to-Bronze or Bronze preparation step. Option D filters rows from transactions into cleaned_transactions, which is also a cleaning/validation step associated with Silver, not Gold.

Exact extract from official Databricks documentation: Databricks describes medallion architecture as improving data through “Bronze ⇒ Silver ⇒ Gold layer tables.” The same official page identifies Silver as “Data cleaning and validation” and Gold as “Dimensional modeling and aggregation.” Databricks also states that the Gold layer “consists of aggregated data tailored for analytics and reporting.”