Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

A)

B)

C)

D)

E)

A . Option A
B . Option B
C . Option C
D . Option D
E . Option E

View Answer

Answer: E

Explanation:

The best practice is to use "Complete" as output mode instead of "append" when working with aggregated tables. Since gold layer is work final aggregated tables, the only option with output mode as complete is option E.