A data engineer is designing a Gold-layer table for a BI team that needs to...

A materialized view stores the result of its defining query and refreshes that result when required. This makes it appropriate for complex Gold-layer joins and aggregations that would otherwise be recomputed whenever a dashboard is opened. Because the source data changes only every few hours, the materialized view can be refreshed according to that update pattern while BI queries read precomputed results with lower latency and reduced resource consumption. A standard view stores only its query definition and executes the underlying computation when queried. A streaming table is intended primarily for incremental or continuously arriving data rather than periodic precomputation of BI aggregations. An external table describes where data is stored but does not inherently precompute query results. Therefore, option B best satisfies the performance and refresh requirements.

================