Answer-first summary for fast verification
Answer: SET spark.databricks.delta.properties.defaults.enableChangeDataFeed = true
The correct statement to enable Change Data Capture (CDC) for all newly created Delta tables is: `SET spark.databricks.delta.properties.defaults.enableChangeDataCapture = true` This configuration sets default properties for all newly created Delta tables, with `enableChangeDataFeed` specifying whether CDC is enabled. Setting it to `true` enables CDC. It's important to note that CDC is not enabled by default for Delta tables and requires explicit activation. Other options either contain typos or incorrect information about CDC being enabled by default. Reference: https://docs.databricks.com/aws/en/delta/delta-change-data-feed
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To enable Change Data Capture (CDC) for all newly created Delta tables, which of the following statements should a data engineering team use?
A
SET spark.databricks.delta.properties.default.enableChangeDataFeed = true
B
All the Delta tables have CDC enabled, by default.
C
SET spark.databricks.delta.properties.defaults.enableChangeDataCapture = true
D
SET spark.databricks.delta.properties.default.enableChangeDataCapture = true
E
SET spark.databricks.delta.properties.defaults.enableChangeDataFeed = true
No comments yet.