DP-700 - Ingest and Transform Data - Section 2.1

Design and implement full and incremental data loads, including watermarking and change detection.

Distinguish full loads from incremental loads, and implement watermark columns and high-water mark logic to identify new or changed rows. Apply change data capture, MERGE into Delta tables for upserts, and idempotent reload patterns to keep target datasets consistent.

full versus incremental load patternswatermark columns and high-water markchange data capture and change trackingupsert and MERGE into Delta tablesidempotent reloads

More in this domain

Back to all Ingest and Transform Data objectives, or the DP-700 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.