In a lakehouse scenario with external data schema changing regularly, which destination action ensures the target matches the external data schema?

• A. Merge
• B. Append
• C. Upsert
• D. Overwrite

Answer: (D)

When the external data schema changes regularly, you want the destination to reflect those changes exactly. Overwrite does this by replacing the existing target with a new one built from the current incoming data, so the target’s fields and types match the external schema. Other approaches rely on the existing schema: merge and upsert expect the same columns to map to, and append adds rows without altering the structure, so they can’t reliably align with a changing schema. Overwrite is the only option that guarantees the target mirrors the latest external schema, even though it may involve recreating or clearing the previous data.