Which statement about LookupRows is correct?

• A. Updates multiple rows in a data extension.
• B. Returns a rowset where a field matches a value, supports additional field/value pairs with AND; maximum 2000 rows.
• C. Returns only the first matching row.
• D. Always runs faster than LookupOrderedRows.

Answer: (B)

LookupRows is used to fetch all rows from a Data Extension that match given field values, returning the results as a rowset. It lets you specify multiple criteria by including additional field/value pairs, and those criteria are combined with AND so a row must meet all conditions to be returned. A key limit to remember is that it returns up to 2000 rows in a single call. It doesn’t modify or update any data in the Data Extension; it’s a read operation. It can return more than one row and isn’t limited to just the first matching row. Performance isn’t guaranteed to be faster than LookupOrderedRows—their speed depends on the data and the specific query, so there isn’t an across-the-board speed advantage.