The LookupOrderedRows example returns which of the following?

The LookupOrderedRows example returns which of the following?

• A. The top 4 Cars rows with highest horsepower that match the MPG condition.
• B. All rows from Cars
• C. Four arbitrary rows
• D. The 4 Cars rows with the lowest horsepower

Answer: (D)

LookupOrderedRows returns a limited, ordered set of rows from a data extension. It uses a specified amount of rows to return, an optional filter, and an order-by field with a direction, so you can control which records show up and in what order. In this example, four rows are requested from the Cars data extension, and the results are ordered by horsepower in ascending order (with an MPG filter applied if present). Because the sort is ascending, you get the cars with the smallest horsepower first, so the four returned rows are the four Cars with the lowest horsepower that meet the MPG condition. If there’s no MPG filter, it’s simply the four Cars with the lowest horsepower. The other options don’t fit because they would involve a different order (highest horsepower), a different number of rows, or no limiting, which isn’t what the example specifies.

LookupOrderedRows returns a limited, ordered set of rows from a data extension. It uses a specified amount of rows to return, an optional filter, and an order-by field with a direction, so you can control which records show up and in what order.

In this example, four rows are requested from the Cars data extension, and the results are ordered by horsepower in ascending order (with an MPG filter applied if present). Because the sort is ascending, you get the cars with the smallest horsepower first, so the four returned rows are the four Cars with the lowest horsepower that meet the MPG condition. If there’s no MPG filter, it’s simply the four Cars with the lowest horsepower.

The other options don’t fit because they would involve a different order (highest horsepower), a different number of rows, or no limiting, which isn’t what the example specifies.