Answer-first summary for fast verification
Answer: CREATE TABLE versions (software string, version string) TBLPROPERTIES (delta.enableChangeDataFeed = true)
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.
Author: LeetQuiz Editorial Team
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.