
Ultimate access to all questions.
Which architectural approach is most effective for preventing duplicate records when streaming data from a multiplexed bronze table into a silver table?
A
Filtering the incoming stream based on an event type column.
B
Applying a full outer join to identify and discard existing records.
C
Employing the dropDuplicates function with a defined composite key.
D
Implementing an incremental MERGE statement without specifying a matching condition.