
Ultimate access to all questions.
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);
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.
E
The SQL statement will not return any error but the Delta table will not be created.