UpsertDE can add a new row if no match is found. Which option reflects this behavior?

• A. It never adds a new row.
• B. It always updates existing rows only.
• C. If no record matches, a new row is added.
• D. It deletes a row if a match is found.

Answer: (C)

UpsertDE uses a merge behavior: it looks for a row that matches the incoming data based on the defined key fields. If a match is found, the existing row is updated with the new values. If no match is found, a new row is inserted into the data extension. This is exactly what the option states: when there is no record that matches, a new row is added.

Why the other ideas don’t fit: upsert is not limited to updating only and never adding new rows, because it inserts when there’s no match. It’s also not about deleting rows when a match is found; deletion isn’t part of upsert behavior.