What does Load Type - Full do?

What does Load Type - Full do?

• A. Drops the table
• B. Only appends new rows
• C. Truncates any data in the Clarity table and re-extracts the entire table from Chronicles
• D. Updates only changed rows

Answer: (C)

Load Type - Full performs a complete refresh: the Clarity table is truncated (all existing rows are removed) and then the entire table is re-extracted from Chronicles. This guarantees the target matches the source exactly, including any deletions, by rebuilding the full dataset rather than applying incremental changes. It differs from options that only append new rows or update only changed rows, which would not replace the entire table. A full load is thorough but can be slower and more resource-intensive, especially for large tables.

Load Type - Full performs a complete refresh: the Clarity table is truncated (all existing rows are removed) and then the entire table is re-extracted from Chronicles. This guarantees the target matches the source exactly, including any deletions, by rebuilding the full dataset rather than applying incremental changes. It differs from options that only append new rows or update only changed rows, which would not replace the entire table. A full load is thorough but can be slower and more resource-intensive, especially for large tables.