Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
When executing the following query on a Delta table named 'customers' with Change Data Feed enabled, what describes the outcome each time the query is run?
.option("readChangeFeed", "true")
.option("startingVersion", 0)
.table("customers")
.filter(col("_change_type").isin(["update_postimage"]))
.write
.mode("overwrite")
.table("customers_updates")
.option("readChangeFeed", "true")
.option("startingVersion", 0)
.table("customers")
.filter(col("_change_type").isin(["update_postimage"]))
.write
.mode("overwrite")
.table("customers_updates")
A
Newly updated records will be merged into the target table, modifying previous entries with the same primary keys.
B
Newly updated records will be appended to the target table.
C
Newly updated records will overwrite the target table.
D
The entire history of updated records will be appended to the target table at each execution, leading to duplicate entries.
E
The entire history of updated records will overwrite the target table at each execution.