Answer-first summary for fast verification
Answer: A refresh schedule with stakeholders included as subscribers
The question asks for the capability that ensures streaming data is included in the dashboard within 10 minutes of being available in gold tables. Option C (A refresh schedule with stakeholders included as subscribers) is correct because it directly addresses the stakeholder requirement for timely updates. Including stakeholders as subscribers ensures they receive notifications or have access to the most current data, aligning with the 10-minute update standard. Option A (always-on SQL Warehouse) is not necessary for refresh schedules and adds unnecessary cost. Option B (10-minute refresh interval) might seem relevant but doesn't guarantee inclusion of stakeholders or address their specific access needs. Option D (Structured Streaming cluster) is unrelated to dashboard refresh mechanisms and pertains to data processing, not visualization updates.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineering team has implemented a Structured Streaming pipeline that processes data in micro-batches every 10 minutes and writes to gold-level tables. A data analyst has built a dashboard using this gold-level data. Project stakeholders require the dashboard to reflect new data within 10 minutes or less of it being available in the gold tables.
Which capability ensures the streaming data is included in the dashboard within the required timeframe?
A
A refresh schedule with an always-on SQL Warehouse (formerly known as SQL Endpoint)
B
A refresh schedule with an interval of 10 minutes or less
C
A refresh schedule with stakeholders included as subscribers
D
A refresh schedule with a Structured Streaming cluster
No comments yet.