Explanation:
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
Ultimate access to all questions.
No comments yet.
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