Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A junior data engineer suggests enabling the Change Data Feed (CDF) feature on a Type 1 table that is overwritten nightly with new data. What is the correct response to this suggestion?
A
CDF cannot be enabled on existing tables; it's only for newly created tables.
B
CDF is beneficial when the table is a Slowly Changing Dimension (SCD) of Type 2.
C
CDF is useful when only a small fraction of records are updated in each batch.
D
Table’s data changes captured by CDF can only be read in streaming mode.
E
All the above are correct responses to the data engineer‘s suggestion.
