Free DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine Demo

Q25 Single choice

A data engineer is using the AUTO CDC API in Lakeflow Spark Declarative Pipeline to propagate deletions from a source table (orders_source) to a target table (orders_target). The source has Change Data Feed (CDF) enabled, but some delete events arrive out of order due to upstream delays.

How does the AUTO CDC API internally ensure deletions are applied correctly despite out-of-order events?

A
It ignores deletions if they arrive after updates for the same key.
B
It manually sorts incoming events by timestamp before applying changes.
C
It runs VACUUM on the target table to purge conflicting records.
D
It uses sequence_by to order events and retains tombstones for deleted rows until older sequences are processed.

DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine demo