Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?

Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table and either consume the change data or skip the current run if no change data exists.

Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
A . SYSTEM$STREAM_HAS_CHANGE_DATA
B . SYSTEM$STREAM_CDC_DATA
C . SYSTEM$STREAM_HAS_DATA
D . SYSTEM$STREAM_DELTA_DATA

View Answer

Answer: C

Explanation:

SYSTEM$STREAM_HAS_DATA

Indicates whether a specified stream contains change data capture (CDC) records.