Explanation:
The Change Data Feed is not auto-enabled for Delta tables; it must be explicitly enabled using the TBLPROPERTIES keyword with delta.enableChangeDataFeed = true. This setting ensures that CDC logs are available for records inserted, updated, or deleted after the property is enabled. Note that delta.enableChangeDataCapture is not the correct property for enabling the Change Data Feed.
Ultimate access to all questions.
Which SQL statement correctly creates a Delta table with the change data feed enabled?
A
Change Data Feed is automatically enabled for all Delta tables.
B
CREATE TABLE versions (software string, version string) TBLPROPERTIES (delta.enableChangeDataFeed = true)
C
CREATE TABLE versions (software string, version string) PROPERTIES (delta.enableChangeDataCapture, True)
D
CREATE TABLE versions (software string, version string) TABLE_PROPERTIES (delta.changeDataFeedEnabled = true)
E
CREATE TABLE versions (software string, version string) TBLPROPERTIES (delta.enableChangeDataCapture, True)
No comments yet.