Which statement about LookupRows is correct?

• A. It updates rows in a data extension.
• B. It sorts results by a default field.
• C. It returns a rowset where a field matches a value, supports additional field/value pairs, and returns up to 2000 rows.
• D. It always returns no more than 100 rows.

Answer: (C)

LookupRows is a server-side JavaScript function used to read data from a Data Extension by matching field values. You pass the Data Extension name, then specify a field and the value it must equal, and you can add more field/value pairs to further filter the results. The function returns a rowset containing all matching rows, with a limit of 2000 rows. It does not update data in the Data Extension, and the order of results is not guaranteed unless you sort it separately. This makes the described behavior the best fit: it returns a rowset for matching field/value criteria, supports additional filters, and has the 2000-row limit.