Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Which SQL statement correctly creates a Delta table with the change data feed enabled?
Which SQL statement correctly creates a Delta table with the change data feed enabled?
Real Exam
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.