Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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)
