Which of the following is true about the UpsertDE function?

• A. This function only works in an email and does not return a value.
• B. This function updates multiple rows and returns the updated count.
• C. This function can be used in landing pages.
• D. This function deletes a row if no match.

Answer: (A)

UpsertDE is an AMPscript function that inserts or updates a row in a Data Extension based on the key values you provide. It can be used in any AMPscript-enabled context, including emails and landing pages, not just in emails. When you call it, the function updates the matching row if it exists or inserts a new one if it doesn’t, and it returns the number of rows affected so you know the result. It does not delete rows—deletion is handled by a different function. Typically one UpsertDE call targets one row (you’d loop or run multiple calls to affect many rows).

So, the true takeaway is that UpsertDE can be used in landing pages and returns a value, while the other statements don’t fit.