Exam Databricks-Certified-Data-Analyst-Associate Topic 4 Question 79 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Analyst-Associate exam
Question #: 79
Topic #: 4
Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

Suggested Answer: E Vote an answer

Option E is correct. A Silver-to-Gold hop typically reads cleaned/refined Silver data and writes aggregated, analytics-ready Gold data. The query reads from sales, groups by store, and aggregates sum( " sales " ), producing a summary table suitable for reporting or dashboarding. That matches the Gold layer. Option A reads from a raw location, which is not Silver-to-Gold. Option D filters invalid units, which is a cleaning step associated with Silver. Options B and C add a derived column but do not create a Gold-level aggregated table.
Official Databricks medallion architecture documentation states that Silver is where data cleanup and validation are performed, while the Gold layer "consists of aggregated data tailored for analytics and reporting." Databricks Structured Streaming documentation also shows .writeStream.outputMode( " complete
" ).toTable(...) as a valid output mode pattern for stateful streaming aggregations.

by Hobart at Nov 18, 2026, 07:17 PM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

0
0
0
10