Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data engineer is creating a Delta table with the following SQL query:
CREATE TABLE data_changes (_change_type STRING, _changed_by STRING) TBLPROPERTIES (delta.enableChangeDataFeed = true);
What will be the outcome of executing this query?
A
The Delta table will be created successfully with the Change Data Feed enabled.
B
The SQL statement will result in an error and the Delta table will not be created.
C
The Delta table will be created successfully but Change Data Feed will not be enabled.
D
The Delta table will be created successfully but the _change_type column will be removed.
_change_type
E
The SQL statement will not return any error but the Delta table will not be created.
