In Incremental load, what data is used to update the table?

In Incremental load, what data is used to update the table?

• A. Data that has changed since the last extraction
• B. All data
• C. Only deleted data
• D. Only new data

Answer: (A)

Incremental load updates a target table by applying only the data that has changed since the last extraction. This delta typically includes new rows and updates to existing rows, identified through timestamps, change data capture logs, or similar markers, so you can upsert or flag deletions as needed without reloading everything. This approach is driven by efficiency: you move only the changes rather than the entire dataset, keeping the table current with minimal resource use. The alternative of loading all data would be a full refresh, which is not incremental. Focusing only on deleted data would miss new and updated rows, and focusing only on new data would miss changes to existing records.

Incremental load updates a target table by applying only the data that has changed since the last extraction. This delta typically includes new rows and updates to existing rows, identified through timestamps, change data capture logs, or similar markers, so you can upsert or flag deletions as needed without reloading everything. This approach is driven by efficiency: you move only the changes rather than the entire dataset, keeping the table current with minimal resource use. The alternative of loading all data would be a full refresh, which is not incremental. Focusing only on deleted data would miss new and updated rows, and focusing only on new data would miss changes to existing records.