70-464 | You need to modify usp_SelectEmployeesByName to support…

Following is 70-464 | You need to modify usp_SelectEmployeesByName to support… from latest Microsoft practice test.

Question: 20

You need to modify usp_SelectEmployeesByName to support server-side paging. The solution must minimize the amount of development effort required. What should you add to usp_SelectEmployeesByName?

A. A table variable
B. The ROWNUMBER keyword
C. An OFFSET-FETCH clause
D. A recursive common table expression

Answer: C